Pages

Wednesday, October 31, 2018

Datediff on databse firebird

Datediff on databse firebird


datediff (hour from current_timestamp to timestamp '12-Jun-2059 06:00')
datediff (minute from time '0:00' to current_time)
datediff (month, current_date, date '1-1-1900')
datediff (day from current_date to cast(? as date))


example :

select datediff(day from current_date to cast('2018-11-01' as date)) from  rdb$database