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.