SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

C-113

CONVERTTIMESTAMP Function

CONVERTTIMESTAMP is a function that converts a Julian timestamp to a DATETIME

value. It returns a value of DATETIME that has the range of fields YEAR TO

FRACTION(6).

julian-timestamp

is an expression that evaluates to a Julian timestamp, which is a LARGEINT value.

Example—CONVERTTIMESTAMP

This example converts a Julian timestamp into a DATETIME value:

>> SELECT CONVERTTIMESTAMP (HIRE_DATE) FROM EMPLOYEE;

COPY Command

COPY is an SQLCI utility command that copies data to and from Guardian files

(including Guardian processes and devices, unstructured disk files, and Enscribe

structured disk files) and SQL tables, appending the data to any existing data, or

displays the contents of a file or table. If you copy data to a table, COPY automatically

updates the indexes of the table.

COPY resembles the FUP COPY command but, unlike FUP COPY, COPY works with

SQL objects.

If SMF is installed on your node, files you specify in COPY syntax cannot be on any

$*.ZYS*. subvolumes. However, remote files on a non-SMF node can reside on any

subvolume.

CONVERTTIMESTAMP ( julian-timestamp )