SYSTIMESTAMP

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

Syntax

SYSTIMESTAMP [ ( ) ]

Example

This example illustrates different formats for SYSDATE, SYSTIME, and SYSTIMESTAMP:

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

Compatibility

Progress extension