Datatypes

New bigtime and bigdatetime datatypes provide precision timestamp information.

Datatypes Description
bigtime A bigtime value includes the hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places.
bigdatetime A bigdatetime value includes the year, month, day, hour, minute, second, and fraction of a second to 6 decimal places.
Two new functions return bigtime and bigdatetime values:
  • current_bigtime
  • current_bigdatetime
bigtime and bigdatetime can be used in these existing functions:
  • datepart
  • datename
  • datediff
  • dateadd
See the Reference Manual: Blocks.