3. Understanding SQL Data Types : Literals : Date and Time Literals : Timestamp Literals
 
Share this page                  
Timestamp Literals
Literals of the ANSI timestamp type have the following format:
TIMESTAMP 'timestamp_value'
timestamp_value
Consists of a date value and a time value separated by a single space. The time value can contain optional fractions of seconds, time zone offset, or both.
Examples:
timestamp '2012-05-29 10:30:00.000-04:00'
timestamp '1918-11-11 11:11:00'