| 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 |