Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateContext variables → CURRENT_TIME
Firebird Home Firebird Home Prev: CURRENT_ROLEFirebird Documentation IndexUp: Context variablesNext: CURRENT_TIMESTAMP

CURRENT_TIME

Available in: DSQL, PSQL, ESQL

Changed in: 2.0

Description: CURRENT_TIME returns the current server time. In versions prior to 2.0, the fractional part used to be always “.0000”, giving an effective precision of 0 decimals. From Firebird 2.0 onward you can specify a precision when polling this variable. The default is still 0 decimals, i.e. seconds precision.

Type: TIME

Syntax: 

CURRENT_TIME [(precision)]

precision  ::=  0 | 1 | 2 | 3

The optional precision argument is not supported in ESQL.

Examples: 

select current_time from rdb$database
-- returns e.g. 14:20:19.6170
select current_time(2) from rdb$database
-- returns e.g. 14:20:23.1200

Notes: 

Prev: CURRENT_ROLEFirebird Documentation IndexUp: Context variablesNext: CURRENT_TIMESTAMP
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateContext variables → CURRENT_TIME