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.