| Firebird Documentation Index → Firebird 2.0 Language Ref. Update → Context variables → CURRENT_TIME |
|
|
|
Available in: DSQL, PSQL, ESQL
Changed in: 2.0
Description: The fractional part of CURRENT_TIME used to be always
“.0000”, giving an effective precision of 0 decimals. Now
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 | 3The optional
precisionargument is not supported in ESQL.
Examples:
select current_time from rdb$database -- returns e.g. 14:20:19.6170select current_time(2) from rdb$database -- returns e.g. 14:20:23.1200
The default precision of CURRENT_TIMESTAMP is now 3 decimals, so
CURRENT_TIMESTAMP is no longer the exact sum of
CURRENT_DATE and CURRENT_TIME, unless you explicitly
specify a precision.
|
| Firebird Documentation Index → Firebird 2.0 Language Ref. Update → Context variables → CURRENT_TIME |