Time

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]]).

SQL

SELECT TIME '1992-09-20 11:30:00.123456';

 time
-----------------
 11:30:00.123456

SQL

SELECT TIMETZ '1992-09-20 11:30:00.123456';

 timetz
--------------------
 11:30:00.123456+00

SQL

SELECT TIMETZ '1992-09-20 11:30:00.123456-02:00';

 timetz
--------------------
 13:30:00.123456+00

SQL

SELECT TIMETZ '1992-09-20 11:30:00.123456+05:30';

 timetz
--------------------
 06:00:00.123456+00

SQL

SELECT '15:30:00.123456789'::TIME_NS;

 time_ns
--------------------
 15:30:00.123456789

TIME_NS values can also be read from Parquet when the type is TIME with unit NANOS.