Date and time literals
Date and time literals are defined by specifing the type name, the sharp character and the desired value; the value format depends on the specific data type, as shown in the table below:
| Type | Example | Explanation |
| DATE | DATE#1980-01-05 | 32 bits value.YYYY-MM-DD |
| LDATE | LDATE#1980-01-05 | 64-bit value.YYYY-MM-DD |
| DATE_AND_TIME | DATE_AND_TIME#1980-01-05-00:05:10orDT#1980-01-05-00:05:10.123 | 32 bits value.YYYY-MM-DD-hh:mm:ss.msMilliseconds are optional, so a valid declaration can stops to seconds.YYYY-MM-DD-hh:mm:ss |
| LDATE_AND_TIME | LDATE_AND_TIME#1980-01-05- 00:05:10.123456orLDT#2080-01-05-20:05:10.123_456_789 | 64 bits value.YYYY-MM-DD-hh:mm:ss.nsMilliseconds, microseconds and nanoseconds are optional, so a valid declaration can stops to seconds.YYYY-MM-DD-hh:mm:ss |
| TIME | TIME#20d5h4m7s20ms | 32 bits value. |
| LTIME | LTIME#105d5h4m7s20ms50us30ns | 64 bits value. |
| TIME_OF_DAY | TOD#13:40:55.123 | 32 bits value. hh:mm:ss.msMilliseconds are optional, so a valid declaration can stops to seconds.hh:mm:ss |
| LTIME_OF_DAY | LTOD#13:40:55.123456789 | 64 bits value. hh:mm:ss.nsMilliseconds, microseconds and nanoseconds are optional, so a valid declaration can stops to seconds.hh:mm:ss |