Sophie

Sophie

distrib > Mandriva > 2010.0 > i586 > media > contrib-release > by-pkgid > 39682d7001fe8b30d488289bb8d6e3df > files > 41

firebird-2.1.3.18185.0-5mdv2010.0.i586.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