Available in: DSQL, ESQL, PSQL
Changed in: 2.0
Description
CURRENT_TIMESTAMP returns the current server date and 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 3 decimals, i.e. milliseconds precision.
Type: TIMESTAMP
Syntax
CURRENT_TIMESTAMP [(precision)] precision ::= 0 | 1 | 2 | 3
The optional precision argument is not supported in ESQL.
Examples
select current_timestamp from rdb$database -- returns e.g. 2008-08-13 14:20:19.6170 select current_timestamp(2) from rdb$database -- returns e.g. 2008-08-13 14:20:23.1200
Notes: