DATE scalar function¶
Returns a DATE constructed from the specified year, month and day (or day of year).
Prototypes¶
DATE(AYEAR INTEGER, AMONTH INTEGER, ADAY INTEGER)
DATE(AYEAR INTEGER, ADOY INTEGER)
RETURNS DATE
Description¶
Returns the DATE value with the components specified by AYEAR, AMONTH and ADAY, or alternatively AYEAR and ADOY the latter of which is the day of year to construct a DATE for.
Parameters¶
- AYEAR
- Specifies the year component of the resulting date.
- AMONTH
- If provided, specifies the month component of the resulting date.
- ADAY
- If provided, specifies the day (of month) component of the resulting date.
- ADOY
- If provided, specifies the day of year from which the month and day components of the resulting date will be calculated (the first day of a year is numbered 1).
Examples¶
Construct a date for first day in February, 2010:
VALUES DATE(2010, 2, 1);
1
----------
2010-02-01
Construct a date for the 180th day of 2009:
VALUES DATE(2009, 180);
1
----------
2009-06-29
See Also¶
- Source code
- TIME scalar function
- DATE (built-in function)