Re: Date Anomaly?? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Date Anomaly??
Date
Msg-id 26997.1052317914@sss.pgh.pa.us
Whole thread Raw
In response to Re: Date Anomaly??  (Thomas Good <tomg@sqlclinic.net>)
Responses Re: Date Anomaly??  (Thomas Good <tomg@sqlclinic.net>)
List pgsql-sql
Thomas Good <tomg@sqlclinic.net> writes:
> Another item: if I say 'export PGDATESTYLE=US' and ask psql for
> the date I get back an ISO date (YYYY-MM-DD).  What region of this
> US is this, I wonder?  Must be San Francisco (maybe Josh knows ;-)

That's only setting a substyle --- one that's not relevant to the ISO
major style (at least not on output).  See the SET reference page.
        regards, tom lane



pgsql-sql by date:

Previous
From: Thomas Good
Date:
Subject: Re: Date Anomaly??
Next
From: Rado Petrik
Date:
Subject: ERROR:  pg_atoi: error in "NULL": can't parse "NULL"