SQL$HELP_OLD72.HLB  —  Built In Functions, SYSTIMESTAMP
    The SYSTIMESTAMP function returns the current date and time as a
    TIMESTAMP type. This function is similar to SYSDATE and CURRENT_
    TIMESTAMP however, its type doesn't change when the SET DEFAULT
    DATE FORMAT command is used.

    Syntax: SYSTIMESTAMP [ ( fractional-seconds-precision ) ]

    The function name can be followed by an optional fractional-
    seconds-precision. This value, if omitted, defaults to 2 and
    accepts the values 0, 1, or 2.

    The following example shows that SYSTIMESTAMP always returns a
    SQL standard date and time.

    SQL> select systimestamp,sysdate,current_timestamp from rdb$database;
     2007-03-27 16:33:32.19   27-MAR-2007 16:33:32.19   27-MAR-2007 16:33:32.19
    1 row selected
    SQL> set default date format 'sql99';
    SQL> select systimestamp,sysdate,current_timestamp from rdb$database;

     2007-03-27 16:33:41.32   2007-03-27 16:33:41.32   2007-03-27 16:33:41.32
    1 row selected
    SQL>
Close Help