> ## 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 CURRENT_DATE function

# CURRENT_DATE

Returns the current local date in the time zone specified in the [session's `time_zone` setting](/reference-sql/system-settings#setting-the-time-zone).

## Syntax

The function can be called with or without parentheses.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
CURRENT_DATE
CURRENT_DATE()
```

## Return Type

`DATE`

## Remarks

The function gets the current timestamp from the system, converts it to the time zone specified in the `time_zone` setting, and truncates it to a `DATE` value.

## Example

The following example assumes that the current timestamp is `2023-03-03 23:59:00 UTC`. Returns `2023-03-04` because the time zone conversion from `UTC` to `Europe/Berlin` shifts the date from `2023-03-03` to `2023-03-04`.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SET time_zone = 'Europe/Berlin';
SELECT CURRENT_DATE();
```