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