HEX
Server: Apache
System: Linux box5514.bluehost.com 5.14.0-162.23.1.9991722448259.nf.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Jul 31 18:11:45 UTC 2024 x86_64
User: smqcdvmy (3893)
PHP: 8.3.30
Disabled: NONE
Upload Files
File: //usr/share/doc/firebird/sql.extensions/README.current_time
----------------------------------
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