Re: European Datestyle - Mailing list pgsql-hackers

From teg@redhat.com (Trond Eivind GlomsrØd)
Subject Re: European Datestyle
Date
Msg-id xuyd7f25ykg.fsf@halden.devel.redhat.com
Whole thread Raw
In response to European Datestyle  (Daniele Orlandi <daniele@orlandi.com>)
List pgsql-hackers
Daniele Orlandi <daniele@orlandi.com> writes:

> Hello,
> 
> Why is this happening ?
> 
> ctonet=# show datestyle;
> NOTICE:  DateStyle is ISO with European conventions
> SHOW VARIABLE
> 
> ctonet=# select creation_date from users limit 1;
>      creation_date      
> ------------------------
>  2000-12-07 04:40:23+01
>  ^^^^^^^^^^

That is the ISO-style, isn't it?

There are two ways of making dates make sense, none of them American
(but hey, they're still using Fahrenheit, feet, lb, fl.oz. acres and
other nonsensical units... )
-- 
Trond Eivind Glomsrød
Red Hat, Inc.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Hash index on macaddr -> crash
Next
From: Tom Lane
Date:
Subject: Re: Re: CRC