Skip site navigation (1) Skip section navigation (2)

Re: changing datestyle

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: karlnack(at)futurityinc(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: changing datestyle
Date: 2009-06-16 13:44:32
Message-ID: 13190.1245159872@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Karl Nack" <karlnack(at)futurityinc(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Karl NackDate: 2009-06-16 17:28:28
Subject: Re: changing datestyle
Previous:From: Bruce HyattDate: 2009-06-16 13:42:07
Subject: Re: Fwd: Yum Update Errors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group