Time Types
The TIME and TIMETZ types specify the hour, minute, second, microsecond of a day.
| Name | Aliases | Description |
|---|---|---|
TIME | TIME WITHOUT TIME ZONE | Time of day |
TIMETZ | TIME WITH TIME ZONE | Time of day, with time zone offset |
TIME_NS | Time of day, nanosecond precision |
Instances can be created using the type names as a keyword, where the data must be formatted according to the ISO 8601 format (hh:mm:ss[.zzzzzz[zzz]][+-TT[:tt]]).
SELECT TIME '1992-09-20 11:30:00.123456';
11:30:00.123456
SELECT TIMETZ '1992-09-20 11:30:00.123456';
11:30:00.123456+00
SELECT TIMETZ '1992-09-20 11:30:00.123456-02:00';
13:30:00.123456+00
SELECT TIMETZ '1992-09-20 11:30:00.123456+05:30';
06:00:00.123456+00
SELECT '15:30:00.123456789'::TIME_NS;
15:30:00.123456789
TIME_NS values can also be read from Parquet when the type is TIME with unit NANOS.
Warning The
TIMEtype should only be used in rare cases, where the date part of the timestamp can be disregarded. Most applications should use theTIMESTAMPtypes to represent their timestamps.