SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-69
Examples—AS DATE/TIME
IN LCT
specifies that the value of the item in the database is encoded as local civil time.
IN GMT
specifies that the value of the item in the database is encoded as Greenwich mean
time, the default. The value formatted for display is always represented as local
civil time.
The range of timestamps for IN GMT starts at 0000/1/1:12:00:00 and ends at
9999/12/31:12:00:00. This allows for the maximum of 12 hours difference between
GMT and LCT so that the LCT value falls within 0000/1/1:00:00:00 and
9999/12/31/23:59:59.999999.
Examples—AS DATE/TIME

This AS clause prints a date in the format March 15, 2004:
AS DATE "MA DB2, Y4"

This clause prints a time value in the format 20:03:45:004:
AS TIME "HB2:M2:S2:C3"

This clause specifies a date format but uses the default time format:
AS DATE "MA DB2, Y4" TIME *
C2 00, 01, ... 99
CB2 0, 1, ... 99
T3 000, 001, ... 999
TB3 0, 1, ... 999
Format Values