Re: [HACKERS] European Datestyle

2000-12-08 Thread Thomas Lockhart
> > 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, The documentation should be clear that this is the correct output, giving the current "datestyle" settings. Ple

Re: [HACKERS] European Datestyle

2000-12-08 Thread Daniele Orlandi
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

Re: [HACKERS] European Datestyle

2000-12-08 Thread Trond Eivind GlomsrØd
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 > > 200

[HACKERS] European Datestyle

2000-12-08 Thread Daniele Orlandi
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