# time type
Expresses a time without a specific date

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


`time` data expresses a time without a specific date.

Detail | Info
-------|------
**Quick Syntax** | `TIME '01:23:45'`
**Size** | 8 bytes
**Catalog name** | `pg_catalog.time`
**OID** | 1083
**Min value** | `TIME '00:00:00'`
**Max value** | `TIME '23:59:59.999999'`

## Syntax



```mzsql
TIME '<time_str>'

```

| Syntax element | Description |
| --- | --- |
| `'<time_str>'` | A string representing a time of day in `H:M:S.NS` format.  |


## Details

### Valid casts

#### From `time`

You can [cast](https://preview.materialize.com/materialize/40269/markdown-docs/sql/functions/cast/index.md) `time` to:

- [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) (implicitly)
- [`text`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/text/index.md) (by assignment)

#### To `time`

You can [cast](https://preview.materialize.com/materialize/40269/markdown-docs/sql/functions/cast/index.md) from the following types to `time`:

- [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) (by assignment)
- [`text`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/text/index.md) (explicitly)
- [`timestamp`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/timestamp/index.md) (by assignment)
- [`timestamptz`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/timestamp/index.md) (by assignment)

### Valid operations

`time` data supports the following operations with other types.

Operation | Computes
----------|------------
[`date`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/date/index.md) `+` [`time`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/time/index.md) | [`timestamp`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/timestamp/index.md)
[`time`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/time/index.md) `+` [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) | `time`
[`time`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/time/index.md) `-` [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) | `time`
[`time`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/time/index.md) `-` [`time`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/time/index.md) | [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md)

## Examples

```mzsql
SELECT TIME '01:23:45' AS t_v;
```
```nofmt
   t_v
----------
 01:23:45
```

<hr/>

```mzsql
SELECT DATE '2001-02-03' + TIME '12:34:56' AS d_t;
```
```nofmt
         d_t
---------------------
 2001-02-03 12:34:56
```