SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
T-5
TIME Data Type
An example of this format is:
3:45:20:16:033
TIME Data Type
Data of type TIME represents a time of day according to a 24-hour clock. Values of
data type TIME are equivalent to values of data type DATETIME declared:
DATETIME HOUR TO SECOND
For more information, see DATETIME Data Type on page D-15.
Example—TIME Data Type
These literals are of data type TIME in (respectively) default, USA, and European
format:
TIME "13:40:05"
TIME "1:40:05 PM"
TIME "13.40.05"
For more information, see Date-Time Literals on page D-10.
TIMESTAMP Data Type
Data of type TIMESTAMP represents a date according to the Gregorian calendar and a
time of day according to a 24-hour clock. Values of data type TIMESTAMP are
equivalent to values of data type DATETIME declared as:
DATETIME YEAR TO FRACTION(6)
For more information, see DATETIME Data Type
on page D-15.
Example—TIMESTAMP Data Type
These literals are of data type TIMESTAMP in (respectively) default, USA, and
European format:
TIMESTAMP "1990-01-22:13:40:05.55"
TIMESTAMP "01/22/1990 01:40:05.55 PM"
TIMESTAMP "22.01.1990 01.13.05.55 PM"
For more information, see Date-Time Literals on page D-10.