Date Time Data Type

The Date Time data type stores an instant of time expressed as a date and time of day. A Date Time literal must be enclosed with number signs (#) and in the format YYYY-MM-DD hh:mm:ss. The supported range of this data type goes from 1900-01-01 00:00:00 to 3000-12-31 23:59:59.

Time AM/PM format is not a supported format to be used in the Date Time literal

The Date Time data type manages the date and time components as a whole, but you can extract the date and time through the built-in functions.

Default value

1900-01-01 00:00:00

Example

#1910-02-02 12:10:05#