DateTime Difference

Description

DateTime Difference Functions can be used to calculate the time difference between two DATEs.

MILLIS_BETWEEN, SECONDS_BETWEEN, MINUTES_BETWEEN, HOURS_BETWEEN, DAYS_BETWEEN, MONTHS_BETWEEN and YEARS_BETWEEN calculate the difference between two DATEs in the corresponding time unit.
DATEDIFF also calculates the difference between two DATEs; the time unit can be specified as an argument.
WORKDAYS_BETWEEN calculates the number of workdays between two DATEs using a specified TFACS style calendar table.
DATE_BETWEEN checks whether a DATE is between two other DATEs.