> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for DATE function

# DATE

Converts a `TIMESTAMP`, `TIMESTAMPTZ`, `DATE`, or `TEXT` value to a `DATE` value. If the conversion cannot be performed, the `DATE` function raises an error.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
DATE(<expression>)
```

### Aliases

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
CAST(<expression> AS DATE)
<expression>::DATE
```

## Parameters

| Parameter      | Description                                          |
| :------------- | :--------------------------------------------------- |
| `<expression>` | The expression that should be converted to a `DATE`. |

## Return Type

The `DATE` function returns a result of type `DATE`. If the conversion cannot be performed, the `DATE` function raises an error. For more information on conversion rules, check out the documentation of the [DATE data type](/reference-sql/data-types/date).

## Example

The following code example converts the `TEXT` value `1990-01-01` to a `DATE` value representing that date:

<div className="query-window">
  ```
  SELECT DATE('1990-01-01');
  ```

  | date <span>date</span> |
  | :--------------------- |
  | 1990-01-01             |

  <p><span>Rows: 1</span><span>Execution time: 5.58ms</span></p>
</div>