TypeTIME WITHOUT TIME ZONE

    Syntax

    The optional precision argument is not supported in ESQL.

    LOCALTIME returns the current server time in the session time zone. The default is 0 decimals, i.e. seconds precision.

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

    • LOCALTIME has a default precision of 0 decimals, where LOCALTIMESTAMP has a default precision of 3 decimals. As a result, LOCALTIMESTAMP is not the exact sum of and LOCALTIME, unless you explicitly specify a precision (i.e. LOCALTIME(3) or LOCALTIMESTAMP(0)).

    1. select localtime from rdb$database
    2. -- returns e.g. 14:20:19.0000
    4. -- returns e.g. 14:20:23.1200

    See also, Section 11.12, LOCALTIMESTAMP