View a markdown version of this page

datestyle - Amazon Redshift
Values (default in bold)DescriptionExample

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 that was published on June 30, 2025.

datestyle

Values (default in bold)

Format specification (ISO, Postgres, SQL, or German), and year/month/day ordering (DMY, MDY, YMD).

  • ISO – uses the datestyle of YYYY-MM-DD HH:MM:SS.

  • Postgres – uses the datestyle of MM-DD HH:MM:SS YYYY.

  • SQL – uses the datestyle of MM-DD-YYYY HH:MM:SS.

  • German – uses the datestyle of DD-MM-YYYY HH:MM:SS.

Description

Sets the display format for date and time values and also the rules for interpreting ambiguous date input values. The string contains two parameters that you can change separately or together.

Example

show datestyle;
DateStyle
-----------
ISO, MDY
(1 row)

set datestyle to 'SQL,DMY';