Current server time in the session time zone, without time zone information

TypeTIME WITHOUT TIME ZONE

Syntax

  |LOCALTIME [ (<precision>) ]
  | 
  |<precision> ::= 0 | 1 | 2 | 3

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.

Since Firebird 4.0, Section 12.4, “CURRENT_TIME” returns a TIME WITH TIME ZONE 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 Section 12.12, “LOCALTIMESTAMP” has a default precision of 3 decimals. As a result, LOCALTIMESTAMP is not the exact sum of Section 12.2, “CURRENT_DATE” and LOCALTIME, unless you explicitly specify a precision (i.e. LOCALTIME(3) or LOCALTIMESTAMP(0)).

Within a PSQL module (procedure, trigger or executable block), the value of LOCALTIME will remain constant every time it is read. If multiple modules call or trigger each other, the value will remain constant throughout the duration of the outermost module. If you need a progressing value in PSQL (e.g. to measure time intervals), use Section 12.14, “'NOW'”.

Examples

  |select localtime from rdb$database
  |-- returns e.g. 14:20:19.0000
  | 
  |select localtime(2) from rdb$database
  |-- returns e.g. 14:20:23.1200

See alsoSection 12.4, “CURRENT_TIME”, Section 12.12, “LOCALTIMESTAMP”