SQL
Time Types
The `TIME` and `TIMETZ` types specify the hour, minute, second, microsecond of a day.  
<div class="narrow_table"></div>  
| Name     | Aliases                  | Description                     |
| :------- | :----------------------- | :------------------------------ |
| `TIME`   | `TIME WITHOUT TIME ZONE` | time of day (ignores time zone) |
| `TIMETZ` | `TIME WITH TIME ZONE`    | time of day (uses time zone)    |  
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][+-TT[:tt]]`).  
```sql
SELECT TIME '1992-09-20 11:30:00.123456';
```  
```text
11:30:00.123456
```  
```sql
SELECT TIMETZ '1992-09-20 11:30:00.123456';
```  
```text
11:30:00.123456+00
```  
```sql
SELECT TIMETZ '1992-09-20 11:30:00.123456-02:00';
```  
```text
13:30:00.123456+00
```  
```sql
SELECT TIMETZ '1992-09-20 11:30:00.123456+05:30';
```  
```text
06:00:00.123456+00
```  
> **Warning.  ** The `TIME` type should only be used in rare cases, where the date part of the timestamp can be disregarded.
> Most applications should use the [`TIMESTAMP` types](#docs:sql:data_types:timestamp) to represent their timestamps.