[HACKERS] European Datestyle
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 ^^ Datestyle has been set either with -e and with "set datestyle" with no change. Context: Postgresql 7.0.3 on RedHat Linux 7.0 - Kernel 2.4.0-test10 - Glibc 2.1.94 and 2.2 Thanks! Bye! -- Daniele Orlandi
Re: [HACKERS] European Datestyle
Daniele Orlandi [EMAIL PROTECTED] 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.
Re: [HACKERS] European Datestyle
Trond Eivind GlomsrØd wrote: 2000-12-07 04:40:23+01 ^^ That is the ISO-style, isn't it? Yes, it is; but according to the documentation (and how it used to be on other machines running PG 6.x) it should be ordered in european format, I don't know if I'm missing something obviuous or what... 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... ) I do not mean to cricticize british units, after all, I would have preferred base16 units instead of base10 :) Bye! -- Daniele --- Daniele Orlandi - Utility Line Italia - http://www.orlandi.com Via Mezzera 29/A - 20030 - Seveso (MI) - Italy ---