Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateExternal functions (UDFs) → getExactTimestamp
Firebird Home Firebird Home Prev: floorFirebird Documentation IndexUp: External functions (UDFs)Next: i64round

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'
Prev: floorFirebird Documentation IndexUp: External functions (UDFs)Next: i64round
Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateExternal functions (UDFs) → getExactTimestamp