Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/) that was published on June 30, 2025. 

# CURRENT\_DATE function
<a name="r_CURRENT_DATE_function"></a>

CURRENT\_DATE returns a date in the current session time zone (UTC by default) in the default format: YYYY-MM-DD.

**Note**  
CURRENT\_DATE returns the start date for the current transaction, not for the start of the current statement. Consider the scenario where you start a transaction containing multiple statements on 10/01/08 23:59, and the statement containing CURRENT\_DATE runs at 10/02/08 00:00. CURRENT\_DATE returns `10/01/08`, not `10/02/08`.

## Syntax
<a name="r_CURRENT_DATE_function-syntax"></a>

```
CURRENT_DATE
```

## Return type
<a name="r_CURRENT_DATE_function-return-type"></a>

DATE

## Examples
<a name="r_CURRENT_DATE_function-examples"></a>

The following example returns the current date (in the AWS Region where the function runs).

```
select current_date;

   date
------------
2008-10-01
```

The following example creates a table, inserts a row where the default of column `todays_date` is CURRENT\_DATE, and then selects all the rows in the table.

```
CREATE TABLE insert_dates(
    label varchar(128) NOT NULL,
    todays_date DATE DEFAULT CURRENT_DATE);

INSERT INTO insert_dates(label)
VALUES('Date row inserted');

SELECT * FROM insert_dates;
         

 label            | todays_date
------------------+-------------
Date row inserted | 2023-05-10
```