TypeTIMESTAMP WITHOUT TIME ZONE

    Syntax

    The optional precision argument is not supported in ESQL.

    LOCALTIMESTAMP returns the current server date and time in the session time zone. The default is 3 decimals, i.e. milliseconds precision.

    • LOCALTIMESTAMP was introduced in Firebird 3.0.4 and Firebird 2.5.9 as a synonym of CURRENT_TIMESTAMP. In Firebird 4.0, CURRENT_TIMESTAMP returns a instead of a TIMESTAMP [WITHOUT TIME ZONE], while LOCALTIMESTAMP returns TIMESTAMP [WITHOUT TIME ZONE]. It is recommended to use LOCALTIMESTAMP when you do not need time zone information.

    • The default precision of LOCALTIME is 0 decimals, so LOCALTIMESTAMP is not the exact sum of CURRENT_DATE and , unless you explicitly specify a precision (i.e. LOCATIME(3) or LOCALTIMESTAMP(0)).

    1. select localtimestamp from rdb$database
    2. -- returns e.g. 2008-08-13 14:20:19.6170
    3. select localtimestamp(2) from rdb$database

    See also, Section 11.11, LOCALTIME