NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-62
AS DATE/TIME Clause
MPF specifies that if the value is negative or positive (MP), the print location is set
immediately to the left of the value (F).
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 the following keywords:
For example, the date formats in the following list cause printing of one of the
corresponding values:
{| DATE { * } |}
{| { "date-string" } |}
AS {| |} [ IN LCT ]
{| TIME { * } |}
{| { "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