SQL$HELP72.HLB  —  Built In Functions, SYSDATE
    The SYSDATE function returns the current date and time. It does
    not require any arguments.

    SYSDATE is a synonym for CURRENT_TIMESTAMP. As with CURRENT_
    TIMESTAMP, the return result of SYSDATE is affected by the
    setting of the SET DEFAULT DATE FORMAT statement, as shown in
    the following example:

    SQL> SET DEFAULT DATE FORMAT 'SQL99'
    SQL> SELECT SYSDATE, CURRENT_TIMESTAMP
    cont>  FROM RDB$DATABASE;

     1995-08-21 15:21:05.29   1995-08-21 15:21:05.29
    1 row selected
    SQL> SET DEFAULT DATE FORMAT 'VMS'
    SQL> SELECT SYSDATE, CURRENT_TIMESTAMP
    cont>  FROM RDB$DATABASE;

     21-AUG-1995 15:21:24.83   21-AUG-1995 15:21:24.83
    1 row selected
Close Help