Skip to main content
Preview BigQuery date and time functions in BigQuery compatibility mode, by BigQuery category. Support is one of: Supported, With limitations, or Not supported.

​
Date functions

BigQuery reference: Date functions.

​
Datetime functions

BigQuery reference: Datetime functions.

​
Timestamp functions

BigQuery reference: Timestamp functions.

​
Time functions

BigQuery reference: Time functions. BigQuery TIME has no native Firebolt type and is emulated on a timezone-naive timestamp, so most time-specific functions are not available.

​
Interval functions

BigQuery reference: Interval functions. An INTERVAL is usable only as a constant or expression operand; see Data types.

​
Format elements

FORMAT_* and PARSE_* accept these BigQuery format elements: %Y %y %m %d %e %j %H %I %M %S %p %b %B %a %A %Q %V %W %U %X %F %T %%, plus the %- no-padding flag.
  • %W and %U (week of year) are translated to the ISO week, which numbers weeks slightly differently from BigQuery near year boundaries.
  • %X expands to HH24:MI:SS.

​
Truncation and diff parts

*_TRUNC and *_DIFF accept: MICROSECOND, MILLISECOND, SECOND, MINUTE, HOUR, DAY, WEEK, ISOWEEK, MONTH, QUARTER, YEAR, DECADE, CENTURY, and MILLENNIUM. *_BUCKET accepts a width of INTERVAL 1 unit only.