getExactTimestamp

`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'