> ## 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.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/date-and-time/date",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> 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":"github-light","dark":"github-dark"}}
DATE(<expression>)
```

### Aliases

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
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:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT DATE('1990-01-01');
```

**Returns**

```
1990-01-01
```