Date / Time Features
Date arithmetic, intervals, time zones, formatting, and temporal queries.
0 features
but not in
Truncate a date or timestamp to a specified precision unit (e.g., month, hour, week), zeroing out less significant components.
DATE_TRUNCTRUNCDATETRUNCdate truncationfloor to month
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Generate a sequence of dates, timestamps, or numbers as a virtual table for use in queries.
GENERATE_SERIESGENERATE_ARRAYGENERATE_DATE_ARRAYdate seriesnumber seriessequence generator
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Add, subtract, and manipulate durations (intervals) with date and timestamp values.
intervalINTERVALdate arithmeticdurationdate math
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery
Store, convert, and display timestamps with full awareness of time zones and UTC offsets.
timezonetime zoneWITH TIME ZONETIMESTAMP WITH TIME ZONEtimestamptzAT TIME ZONECONVERT_TIMEZONE
Postgres
MySQL
MariaDB
Oracle
SQL Server
SQLite
Redshift
DB2
Snowflake
BigQuery