• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# interval()

Description:

Compute the number of days between two datetime values.

Syntax:

interval (t1,t2)

t1- t2    Equivalent to interval (t2, t1)

Note:

The function computes the number of days between two datetime values t1 and t2.

Parameter:

 t1 A date value, datetime value or integer; when it is an integer, it can be understood as value of days@o() t2 A date value, datetime value or integer; when it is an integer, it can be understood as value of days@o()

Option:

 @y Compute the number of years between two datetime values @q Compute the number of quarters between two datetime values @m Compute the number of months between two datetime values @s Compute the number of seconds between two datetime values @ms Compute the number of milliseconds between two datetime values @r Compute the interval between two datetime values and return a real number @w Compute the number of weeks between two datetime values @7 Compute the number of Sundays between two datetime values according to a left-open interval @1 Compute the number of Mondays between two datetime values according to a left-open interval

Return value:

Integer

Example:

 interval(datetime("19800227","yyyyMMdd"),datetime("1983-02-27 00:00:45")) 1097 interval@y(datetime("19800227","yyyyMMdd"),datetime("1983-02-27 00:00:45")) 3 interval@q(datetime("19800227","yyyyMMdd"),datetime("1983-02-27 00:00:45")) 12 interval@m(datetime("19800227","yyyyMMdd"),datetime("1983-02-27 00:00:45")) 36 interval@s(datetime("19800227","yyyyMMdd"),datetime("1980-02-27 00:00:45")) 45 interval@s ("1972-11-08 10:20:30","1972-11-08 10:30:50") 620 interval@ms(datetime("19800227","yyyyMMdd"),datetime("1980-02-27 00:00:45")) 45,000 interval@ms("1972-11-08 10:20:30","1972-11-08 10:30:50") 620,000 interval@r(datetime("19800227","yyyyMMdd"),datetime("1980-02-27 00:00:45")) 5.208333333333333E-4 interval@r("1972-11-08 10:20:30","1973-11-08 10:30:50") 365.00717592592594 datetime("19850227","yyyyMMdd")-datetime("1983-02-27 00:00:45") 730 interval@w("1972-10-08 10:20:30","1972-11-08 10:30:50") 4 interval@7("1972-10-08 10:20:30","1972-11-08 10:30:50") 4 interval@1("1972-10-08 10:20:30","1972-11-08 10:30:50") 5 interval@y(15899,23545) 20 interval@y(date@o(15899),date@o(23545)) 20