---
last_updated: "2026-09-22T11:50:48.000Z"
title: Date
meta:
    description: Documentation for the Date data type.
---

# Date

A date. Stored in two bytes as the number of days since 1970-01-01 (unsigned). Allows storing values from immediately after the beginning of the Unix Epoch to the upper threshold defined by a constant at the compilation stage (currently, this is until the year 2149, but the final fully supported year is 2148).

Supported range of values: \[1970-01-01, 2149-06-06\].

The date value is stored without the time zone.

### Example

```sql {% title="Using the Date data type" %}
SELECT
    toDate('2023-10-26') AS date_from_string,
    toDate(19649) AS date_from_days_since_epoch;
```

Result:

```text {% title="Query result" %}
┌─date_from_string─┬─date_from_days_since_epoch─┐
│       2023-10-26 │                 2023-10-26 │
└──────────────────┴────────────────────────────┘
```