Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

datestyle

Values (Default in Bold)

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

ISO, MDY

Description

Sets the display format for date and time values as well as the rules for interpreting ambiguous date input values. The string contains two parameters that can be changed separately or together.

Example

Copy
show datestyle; DateStyle ----------- ISO, MDY (1 row) set datestyle to 'SQL,DMY';