# date type
Expresses a date without a specified time

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


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

Detail | Info
-------|------
**Quick Syntax** | `DATE '2007-02-01'`
**Size** | 4 bytes
**Catalog name** | `pg_catalog.date`
**OID** | 1082
**Min value** | 4714-11-24 BC
**Max value** | 262143-12-31 AD
**Resolution** | 1 day

## Syntax



```mzsql
DATE '<date_str>' [<time_str>] [<tz_offset>]

```

| Syntax element | Description |
| --- | --- |
| `'<date_str>'` | A string representing a date in `Y-M-D`, `Y M-D`, `Y M D` or `YMD` format.  |
| `<time_str>` | _(NOP)_ A string representing a time of day in `H:M:S.NS` format. Can be separated from `<date_str>` by `T`.  |
| `<tz_offset>` | _(NOP)_ The timezone's distance from UTC, in hours, specified as `+HH` or `-HH`.  |


## Details

### Valid casts

#### From `date`

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

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

#### To `date`

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

- [`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) `+` [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) | [`timestamp`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/timestamp/index.md)
[`date`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/date/index.md) `-` [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) | [`timestamp`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/timestamp/index.md)
[`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)
[`date`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/date/index.md) `-` [`date`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/date/index.md) | [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md)

## Examples

```mzsql
SELECT DATE '2007-02-01' AS date_v;
```
```nofmt
   date_v
------------
 2007-02-01
```