|
|
|
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 c-treeSQL 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
