Ask AI about
"
"
OR
Ask AI
Star us on Github
Join us on Slack
Start Now
YugabyteDB Aeon
Try our fully-managed cloud DBaaS for free.
No credit card required
Sign up
YugabyteDB
Try our open source distributed SQL database on your laptop.
Download
Products
YugabyteDB
The open source distributed SQL database
YugabyteDB Anywhere
Self-managed cloud DBaaS
YugabyteDB Aeon
Fully-managed cloud DBaaS
YugabyteDB Voyager
Database migration service
Develop
Integrations
API
SQL APIs
YSQL
YCQL
Clients
ysqlsh
ycqlsh
Management APIs
YugabyteDB Anywhere API
YugabyteDB Aeon API
FAQ
Releases
YugabyteDB
YugabyteDB Anywhere
YugabyteDB Aeon
YugabyteDB Voyager
YugabyteDB Clients
Tech Advisories
YugabyteDB
API
YSQL
Data types
Date and time
Semantics of the date-time data types
v2.25
Preview
Preview release - not for production
v2025.1
STS
Stable release with standard-term support
v2.25
Preview
Preview release - not for production
v2024.2
LTS
Stable release with long-term support
v2024.1
STS
Stable release with standard-term support
v2.20
LTS
Stable release with long-term support
Unsupported versions
The semantics of the date-time data types
Contribute
Report a doc issue
Suggest new content
Edit this page
Contributor guide
The following subsections define the semantics of the
date-time
data types:
The
date
data type
The
time
data type
The plain
timestamp
and
timestamptz
data types
The
interval
data type and its variants
![Semantics of the date-time data types [YSQL]](/images/section_icons/api/subsection.png "Semantics of the date-time data types [YSQL]"){kind=icon}
Contribute