SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-67
AS DATE/TIME Clause
AS DATE/TIME Clause
The AS DATE/TIME clause specifies a format for printing a date and time in the
BREAK FOOTING, BREAK TITLE, DETAIL, PAGE FOOTING, PAGE TITLE, REPORT
FOOTING, and REPORT TITLE report writer commands.
Print items printed with AS DATE/TIME must be in Julian timestamp format. To convert
dates and times in other formats to Julian timestamps, use the
COMPUTE_TIMESTAMP function.
*
specifies the default format, which is the current setting of the DATE_FORMAT
style option (for a date) and the current setting of the TIME_FORMAT style option
(for a time).
"date-string"
is a string that specifies how to format a date. It can include blanks, commas,
hyphens, periods, slashes, and these keywords:
For example, the date formats in this list cause printing of one of the corresponding
values:
{| DATE { * } |}
{| { "date-string" } |}
AS {| |} [ IN LCT ]
{| TIME { * } |} [ IN GMT ]
{| { "time-string" } |}
M[n] Specifies a month
D[n] Specifies a day
Y[n] Specifies a year
A[n] Spells out the month or day. If you specify An, only n bytes are displayed.
B[n] Suppresses leading zeros
O[n] Spells out the number of the day. If you specify On, only n bytes are
displayed.
n An integer that specifies the minimum number of bytes (1-3) or digits
(1-4) to print. The default value of n is 1.
Format Values
MA January, February, ... December
MA3 Jan, Feb, ... Dec
M2 01, 02, ... 12
M 1, 2, ... 12
MB2 1, 2, ... 12