Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateContext variables → CURRENT_TIMESTAMP
Firebird Home Firebird Home Prev: CURRENT_TIMEFirebird Documentation IndexUp: Context variablesNext: CURRENT_TRANSACTION

CURRENT_TIMESTAMP

Available in: DSQL, PSQL, ESQL

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: 

Prev: CURRENT_TIMEFirebird Documentation IndexUp: Context variablesNext: CURRENT_TRANSACTION
Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateContext variables → CURRENT_TIMESTAMP