getExactTimestamp

<< floor | FB 2.5 Language Reference | i64round >>
<< floor | FB 2.1 Language Reference | 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'

back to top of page
<< floor | FB 2.5 Language Reference | i64round >>
<< floor | FB 2.1 Language Reference | i64round >>