Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

RDB/VMS SQL CURRENT_TIMESTAMP — VMS RDB_4.0B

 Specifies the date and time in the format currently defined in
 Rdb/VMS.

 The CURRENT_TIMESTAMP keyword is accessible from anywhere that
 an expression is allowed in Rdb/VMS.  Below is an example of an
 SQL statement that inserts the date into the START_DATE field of
 an employees record:

    SQL> INSERT INTO EMPLOYEES(JOB_START ...)
                    VALUES (CURRENT_TIMESTAMP, ...);

 If you use the CURRENT_TIMESTAMP keyword more than once within a
 statement, it retains the same value for the date and time.

 You can also use the CURRENT_TIMESTAMP keyword within triggers.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026