DATE
Creates a date value out of integers.
Numbers will be rounded to integers. |
There is also a conversion function DATE. |
Syntax
DATE ( year , month , day ) |
Inputs
- year - An integer value between and including 1 and 9999 that represents the year in the constructed date.
- month - An integer value between and including 1 and 12 that represents the month in the constructed date.
- day - An integer value between and including 1 and 31 that represents the day in the constructed date.
Return type
- date
Examples
| Expression | Result | Type |
|---|---|---|
| DATE ( 2010 , 5 , 25 ) | 25-5-2010 | Date |
| DATE ( -2010 , 5 , 25 ) | UNKNOWN | Date |
| DATE ( 2010 , 2 , 29 ) | Error |