Wiki / Configuration Parameters

Sets the display format for date and time values, as well as the rules for interpreting ambiguous date input values. For historical reasons, this variable contains two independent components: the output format specification (ISO, Postgres, SQL, or German) and the input/output specification for year/month/day ordering (DMY, MDY, or YMD). These can be set separately or together. The keywords Euro and European are synonyms for DMY; the keywords US, NonEuro, and NonEuropean are synonyms for MDY. See Section 8.5 for more information. The built-in default is ISO, MDY, but initdb will initialize the configuration file with a setting that corresponds to the behavior of the chosen lc_time locale.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

ISO, MDY

category

Client Connection Defaults / Locale and Formatting

context

user

documented

true

enumvals

Unknown

extra desc

Also controls interpretation of ambiguous date inputs.

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

DateStyle

short desc

Sets the display format for date and time values.

source

pg-settings-source-snapshot

unit

Unknown

vartype

string