Try OpenEdge Now
skip to main content
ABL Reference
ABL Syntax Reference : INTERVAL function

INTERVAL function

Returns the time interval between two DATE, DATETIME, or DATETIME-TZ values as an INT64 value.


INTERVAL ( datetime1 , datetime2 , interval-unit )
An expression whose value is a DATE, DATETIME, or DATETIME-TZ.
An expression whose value is a DATE, DATETIME, or DATETIME-TZ.
A character constant, or a character expression that evaluates to one of the following time units: ‘years', ‘months', ‘weeks', ‘days', 'hours', ‘minutes', ‘seconds' or ‘milliseconds'. These values are case insensitive and might be singular.


*This function returns a signed integer value (positive or negative). For example, if datetime1 is less than datetime2, the INTERVAL function returns a negative value.
*If datetime1 or datetime2 is a DATE or DATETIME, the time value defaults to midnight and the time zone value defaults to the session's time zone, respectively.
*You are responsible for managing value overflow, if any.
*When used with 'months', the INTERVAL function does not take into account that not all months have the same number of days. For example, when determining if an interval between dates in two consecutive months is one full month, the function only checks to see if the day in the date of the later month is greater than or equal to the day in the date of the earlier month. Both of the following function calls return '0', i.e., not a full month, in spite of the fact that the second example involves the calendar end dates of March and April.


See also

- Date subtraction operator, - Datetime subtraction operator, ADD-INTERVAL function, DATE function, DATETIME function, DATETIME-TZ function