Sophie

Sophie

distrib > Mageia > 4 > x86_64 > by-pkgid > 1c8446a19d18712de0208510fe1d2c35 > files > 110

firebird-2.5.2.26540-3.mga4.x86_64.rpm

----------------------------------
CURRENT_TIME and CURRENT_TIMESTAMP
----------------------------------

  Function:
    Returns current server system time or date+time values.

  Syntax rules:
    CURRENT_TIME [(<seconds precision>)]
    CURRENT_TIMESTAMP [(<seconds precision>)]

  Type:
    TIME, TIMESTAMP

  Scope:
    DSQL, PSQL

  Example(s):
    1. SELECT CURRENT_TIME FROM RDB$DATABASE;
    2. SELECT CURRENT_TIME(3) FROM RDB$DATABASE;
    3. SELECT CURRENT_TIMESTAMP(3) FROM RDB$DATABASE;

  Note(s):
    1. The maximum possible precision is 3 which means accuracy of 1/1000 second
       (one millisecond). This accuracy may be improved in the future versions.
    2. If no seconds precision is specified, the following values are implicit:
       - 0 for CURRENT_TIME
       - 3 for CURRENT_TIMESTAMP