Jump to main content
Yellowbrick Documentation
Product Documentation
yellowbrick.com
Technical Support
ⓘ
Documentation Version 5.2
Search
Home
Documentation Version 5.2
SQL Reference
SQL Functions and Operators
Datetime Functions
Documentation Version 5.2
What's New in Version 5.2
System Management
Client Tools and Drivers
ybsql Reference
Database Administration
Loading and Unloading Data
Workload Management
Backup and Restore
Database Replication
SQL Reference
SQL Data Types
SQL Commands
SQL Functions and Operators
Supported Functions and Return Types
SQL Conditions
String Functions
Pattern Matching
Datetime Functions
ADD_MONTHS
AGE
AT TIME ZONE
CURRENT_DATE
CURRENT_TIMESTAMP
CURRENT_UTC_TIMESTAMP()
DATEADD
DATEDIFF
DATENAME
DATE_PART
DATE_TRUNC
DAY
DAYS_BETWEEN
EOMONTH
EXTRACT
GETDATE
JUSTIFY_DAYS, _HOURS, _INTERVAL
LAST_DAY
LOCALTIME
LOCALTIMESTAMP
MAKE_DATE
MAKE_INTERVAL
MAKE_TIME
MAKE_TIMESTAMP
MAKE_TIMESTAMPTZ
MONTH
MONTHS_BETWEEN
NEXT_DAY
NOW()
OVERLAPS
TIMEOFDAY()
TIMEZONE
YEAR
Supported Dateparts
Mathematical Functions
Aggregate Functions
Window Functions
Conditional Expressions
Formatting Functions
Type-Safe Casting Functions
JSON Functions
CONVERT (SQL Server Migration Function)
GETBIT Function
NEXTVAL Function
System Functions
Network Address Functions
SQL Reserved Words
SQL Quick Reference
Error Codes
Glossary
Notices and Licenses
Datetime Functions
This section covers functions that work with datetime data types and literals.
ADD_MONTHS
AGE
AT TIME ZONE
CURRENT_DATE
CURRENT_TIMESTAMP
CURRENT_UTC_TIMESTAMP()
DATEADD
DATEDIFF
DATENAME
DATE_PART
DATE_TRUNC
DAY
DAYS_BETWEEN
EOMONTH
EXTRACT
GETDATE
JUSTIFY_DAYS, _HOURS, _INTERVAL
LAST_DAY
LOCALTIME
LOCALTIMESTAMP
MAKE_DATE
MAKE_INTERVAL
MAKE_TIME
MAKE_TIMESTAMP
MAKE_TIMESTAMPTZ
MONTH
MONTHS_BETWEEN
NEXT_DAY
NOW()
OVERLAPS
TIMEOFDAY()
TIMEZONE
YEAR
Supported Dateparts