3. Understanding SQL Data Types : Literals : Date and Time Literals
 
Share this page                  
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.