Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateInternal functions → DATEDIFF()
Firebird Home Firebird Home Prev: DATEADD()Firebird Documentation IndexUp: Internal functionsNext: DECODE()

DATEDIFF()

Available in: DSQL, PSQL

Added in: 2.1

Description: Returns the number of years, months, days, hours, minutes, seconds or milliseconds elapsed between two date/time values.

Result type: BIGINT

Syntax: 

DATEDIFF (<args>)

<args>     ::=  <unit> FROM <moment1> TO <moment2>
                | <unit>, <moment1>, <moment2>

<unit>     ::=  YEAR | MONTH | DAY
                  | HOUR | MINUTE | SECOND | MILLISECOND
<momentN>  ::=  a DATE, TIME or TIMESTAMP expression
  • DATE and TIMESTAMP arguments can be combined. No other mixes are allowed.

  • With DATE arguments, only YEAR, MONTH and DAY can be used.

  • With TIME arguments, only HOUR, MINUTE, SECOND and MILLISECOND can be used.

Computation: 

Examples: 

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))
Prev: DATEADD()Firebird Documentation IndexUp: Internal functionsNext: DECODE()
Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateInternal functions → DATEDIFF()