Progress
SQL-92
Guide and Reference


SYSTIMESTAMP Function

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/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 

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095