README.current_time 814 B

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