![DAYNAME function [Date and time]](arrow-left.gif){kind=icon}
![DB_ID function [System]](arrow-right.gif){kind=icon}
Returns the number of days since an arbitrary starting date, returns the number of days between two specified dates, or adds the specified integer-expression number of days to a given date.
DAYS ( datetime-expression ) | ( datetime-expression, datetime-expression ) | ( datetime-expression, integer-expression )
datetime-expression A date and time.
integer-expression The number of days to be added to the datetime-expression. If the integer-expression is negative, the appropriate number of days are subtracted from the date/time. If you supply an integer expression, the datetime-expression must be explicitly cast as a date.
For information on casting data types, see the section “CAST function [Data type conversion]”.
DAYS ignores hours, minutes, and seconds.
The following statement returns the integer value 729948.
SELECT DAYS( '1998-07-13 06:07:12' ) FROM iq_dummy
The following statement returns the integer value -366, which is the difference between the two dates.
SELECT DAYS( '1998-07-13 06:07:12', '1997-07-12 10:07:12' ) FROM iq_dummy
The following statement returns the value 1999-07-14:
SELECT DAYS( CAST('1998-07-13' AS DATE ), 366 )
FROM iq_dummy
