Date time
PostgreSQL Data Type Date time
Type |
Size |
Min value |
Max value |
Descripiton |
timestamp without time zone |
8 bytes |
4713 BC |
- |
without timezone |
timestamp with time zone |
8 bytes |
4713 BC |
- |
with timezone |
date |
4 bytes |
4713 BC |
- |
date(without time)) |
time without time zone |
8 bytes |
00:00:00 |
- |
time(without timezone) |
time with time zone |
12 bytes |
00:00:00_1459 |
- |
time(with timezone) |
interval |
16 bytes |
-178000000 years |
- |
Time interval |
interval
- YEAR
- MONTH
- DAY
- HOUR
- MINUTE
- SECOND
- YEAR TO MONTH
- DAY TO HOUR
- DAY TO MINUTE
- DAY TO SECOND
- HOUR TO MINUTE
- HOUR TO SECOND
- MINUTE TO SECOND
Special Keyword
Special Keyword |
Available Type |
Description |
epoch |
date, timestamp |
1970-01-01 00:00:00+00 (Unix system time zero) |
infinity |
date, timestamp |
Max time |
-infinity |
date, timestamp |
Min time |
now |
date, time, timestamp |
Current time |
today |
date, timestamp |
Today mid-night 00:00 |
tomorrow |
date, timestamp |
Tomorrow mid-night 00:00 |
yesterday |
date, timestamp |
Yesterday mid-night 00:00 |
allballs |
time |
00:00:00.00 UTC |
Format |
Dexcription |
Example |
ISO |
ISO 8601, SQL standard |
1997-12-17 07:37:16-08 |
SQL |
traditional style |
12/17/1997 07:37:16.00 PST |
Postgres |
original style |
Wed Dec 17 07:37:16 1997 PST |
German |
regional style |
17.12.1997 07:37:16.00 PST |
Reference