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
CURRENT_DATE function
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
CURRENT_DATE
Return type
DATE
Examples
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
