Date and time literals specify ANSI compliant date/time values. There are four types of date and time literals:

Date and time literals can be assigned to the corresponding date and time data type without using an explicit conversion function. The value is coded as a quoted string, but is automatically converted to the appropriate internal value.