Firebolt Documentation home page
Search...
⌘K
Ask AI
Contact us
Book a demo
Book a demo
Search...
Navigation
Date and time functions
Date and time functions
Documentation
Firebolt Core
📰 Blog
What is Firebolt?
Overview
Platform capabilities
Overview
Overview
Architecture
Pricing and billing
Organizations and accounts
Engine Fundamentals
Data modeling
Data management
Queries
Table and Column Compression
Security
Guides
Run queries
Manage organization
Get started
Operate Engines
SQL Dialect
Load data
Export data
Configure security
Develop with Firebolt
Integrate with Firebolt
Migrate to Firebolt
SQL reference
Overview
Data types
Information schema
Operators
SQL commands
SQL functions
Overview
Functions glossary
Aggregation functions
Array functions
Binary functions
Conditional and miscellaneous functions
DataSketches functions
Date and time functions
Overview
AGO
CURRENT_DATE
CURRENT_TIMESTAMP
DATE_ADD
DATE_DIFF
DATE_TRUNC
DATE
EXTRACT
LOCALTIMESTAMP
TO_CHAR
TO_DATE
TO_TIMESTAMP
TO_YYYYMM
TO_YYYYMMDD
Geospatial functions
JSON functions
Lambda functions
Numeric functions
Session functions
String functions
Table-valued functions
Vector functions
Window functions
General reference
Overview
Release notes
Available regions
System settings
Object identifers
Reserved words
Arithmetic with intervals
Help menu
API reference
Overview
Synchronous queries
Asynchronous queries
On this page
Date and time functions
Date and time functions
Date and time functions
Reference for date and time functions
Date and time functions
Assistant
Responses are generated using AI and may contain mistakes.
APACHE_DATASKETCHES_HLL_MERGE
AGO