meta data for this page
  •  

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'