NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-109
CONVERTTIMESTAMP Function
END_HOUR_5_2 PIC 9(2) NOT NULL,
PRIMARY KEY (
DEP_KEY ,
EMP_KEY
)
)
ORGANIZATION KEY SEQUENCED
...
NO BUFFERED
;
Each elementary item of the OCCURS group is converted to a column. The two
fields of the EMPNUM-KEY group, which redefined EMPNUM, are used as the
primary key of the table. The following command performs the conversion:
>> OBEY SCHDCONV;
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.
Examples—CONVERTTIMESTAMP
•
The following 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.
CONVERTTIMESTAMP ( julian-timestamp )