Release 10.1A: OpenEdge Data Management:
SQL Reference

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

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