Re: changing datestyle - Mailing list pgsql-novice

From Tom Lane
Subject Re: changing datestyle
Date
Msg-id 13190.1245159872@sss.pgh.pa.us
Whole thread Raw
In response to changing datestyle  ("Karl Nack" <karlnack@futurityinc.com>)
Responses Re: changing datestyle
List pgsql-novice
"Karl Nack" <karlnack@futurityinc.com> writes:
> This is driving me a little nuts.
> SET datestyle = 'us';
> And yet datestyle continues to come back as 'ISO, MDY'.

That's exactly what it should do.  'US' is a synonym for 'MDY',
and in any case it determines only one of the two components
of DateStyle.

(The fact that there are two components is a historical aberration,
and I'd be the first to agree it's ugly, but that's how it works.)

> What am I missing?

You need to read the manual a bit more closely, perhaps; or at
least explain what your *actual* problem is.

            regards, tom lane

pgsql-novice by date:

Previous
From: Bruce Hyatt
Date:
Subject: Re: Fwd: Yum Update Errors
Next
From: Karl Nack
Date:
Subject: Re: changing datestyle