Firebird Documentation Index → Firebird 2.0 Language Ref. Update → External functions (UDFs) → getExactTimestamp |
Library: fbudf
Added in: 1.0 (Win), 1.5 (Linux)
Better alternative: CURRENT_TIMESTAMP
or 'NOW'
Description: Returns the system time with milliseconds precision. This function was added because in pre-2.0 versions, CURRENT_TIMESTAMP
always had .0000
in the fractional part of the second. In Firebird 2.0 and up it is better to use CURRENT_TIMESTAMP
, which now also defaults to milliseconds precision. To measure time intervals in PSQL modules, use 'NOW'
.
Result type: TIMESTAMP
Syntax:
getexacttimestamp()
Declaration:
DECLARE EXTERNAL FUNCTION getExactTimestamp TIMESTAMP RETURNS PARAMETER 1 ENTRY_POINT 'getExactTimestamp' MODULE_NAME 'fbudf'
Firebird Documentation Index → Firebird 2.0 Language Ref. Update → External functions (UDFs) → getExactTimestamp |