DATETIME
Creates a dateTime value out of integers.
Numbers will be rounded to integers. |
There is also a conversion function DATETIME. |
Syntax
DATETIME ( year , month , day , hour , minute , second ) |
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.
- hour - An integer value between and including 0 and 23 that represents the hours in the constructed time.
- minute - An integer value between and including 0 and 59 that represents the minutes in the constructed time.
- second - An integer value between and including 0 and 59 that represents the seconds in the constructed time.
Return type
- dateTime
Examples
| Expression | Result | Type |
|---|---|---|
| DATETIME ( 2010 , 5 , 25 , 23 , 00 , 00 ) | 25-5-2010 23:00:00 | DateTime |
| DATETIME ( -2010 , 5 , 25 , 23 , 00 , 00 ) | UNKNOWN | DateTime |
| DATETIME ( 2010 , 5 , 25 , 45 , 00 , 00 ) | UNKNOWN | DateTime |