Date and Time Literals
Date and time literals specify ANSI compliant date/time values. There are four types of date and time literals:
• date
• time
• timestamp
• interval
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.