4.9.2.84 SYSTIMESTAMP function (extension)

Syntax

SYSTIMESTAMP [ ( ) ]

Description

SYSTIMESTAMP returns the current date and time as a TIMESTAMP value. This function takes no arguments, and the trailing parentheses are optional.

The following SQL example shows the different formats for SYSDATE, SYSTIME, and SYSTIMESTAMP:

SELECT SYSDATE FROM test;
SYSDATE
-------
09/13/1994
1 record selected
SELECT SYSTIME FROM test;
SYSTIME
-------
14:44:07:000
1 record selected
SELECT SYSTIMESTAMP FROM test;
SYSTIMESTAMP
------------
1994-09-13 14:44:15:000
1 record selected