NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-58
Examples—COMPUTE_TIMESTAMP
For the third form, any of the arguments can be either a numeric literal or a column
identifier (but not a numeric expression).
The range of valid dates is from 01/02/0001 00:00:00:000:000 through 12/31/3999
00:00:00:000:000.
•
Not compatible with date-time data types
Note that COMPUTE_TIMESTAMP returns a value of data type NUMERIC(18) or
LARGEINT, not data type TIMESTAMP or DATETIME YEAR TO FRACTION.
Examples—COMPUTE_TIMESTAMP
•
The following SQLCI command sets the parameter ?D to the Julian timestamp for
the date and time in parentheses:
SET PARAM ?D COMPUTE_TIMESTAMP (2/8/93 13:25:00:00:00);
CONCAT Clause
CONCAT is an SQLCI report writer clause that specifies print items to display without
intervening or trailing spaces.
CONCAT works in the BREAK FOOTING, BREAK TITLE, DETAIL, PAGE
FOOTING, PAGE TITLE, REPORT FOOTING, and REPORT TITLE report writer
commands.
print-item
is an item to concatenate and, optionally, a set of instructions for formatting the
item.
CONCAT ( print-list ) [ AS format ]
print-list is:
print-item [ , print-item ]
print-item is:
{ { { column-id } [ AS format ] } [ STRIP ] }
{ { { literal } } }
{ { { arith-expr } } }
{ { } }
{ { CONCAT ( print-list ) [AS format] } }
{ { } }
{ { IF cond-expr THEN ( print-list ) } }
{ { [ ELSE ( print-list ) ] } }
{ }
{ SPACE [number] }