Debian Codegraph @

doc/sql.extensions/README.current_time

raw
1 ----------------------------------
2 CURRENT_TIME and CURRENT_TIMESTAMP
3 ----------------------------------
4
5 Function:
6 Returns current server system time or date+time values.
7
8 Syntax rules:
9 CURRENT_TIME [(<seconds precision>)]
10 CURRENT_TIMESTAMP [(<seconds precision>)]
11
12 Type:
13 TIME, TIMESTAMP
14
15 Scope:
16 DSQL, PSQL
17
18 Example(s):
19 1. SELECT CURRENT_TIME FROM RDB$DATABASE;
20 2. SELECT CURRENT_TIME(3) FROM RDB$DATABASE;
21 3. SELECT CURRENT_TIMESTAMP(3) FROM RDB$DATABASE;
22
23 Note(s):
24 1. The maximum possible precision is 3 which means accuracy of 1/1000 second
25 (one millisecond). This accuracy may be improved in the future versions.
26 2. If no seconds precision is specified, the following values are implicit:
27 - 0 for CURRENT_TIME
28 - 3 for CURRENT_TIMESTAMP