datestyle problems? - Mailing list pgsql-general

From Geoff Russell
Subject datestyle problems?
Date
Msg-id Pine.GSO.4.05.10009071033530.2841-100000@magnum
Whole thread Raw
Responses Re: datestyle problems?
List pgsql-general
Hi,

Have I missed something, or has some date behaviour
changed in going from 6.5.2 to 7.0.2?

drop table tdate;
create table tdate ( demo date );
set DateStyle to 'European';
insert into tdate (demo) values ('31-12-1999');
set DateStyle to 'US'; select demo as US from tdate;
set DateStyle to 'European'; select demo as European from tdate;
set DateStyle to 'SQL'; select demo as SQL from tdate;
set DateStyle to 'ISO'; select demo as ISO from tdate;
set DateStyle to 'German'; select demo as German from tdate;

Gives (with irrelevant lines deleted):
>        us
>   ------------
>    1999-12-31
Wrong? should be month day year;
>
>     european
>   ------------
>    1999-12-31
Wrong? should be day month year;
>
>       sql
>   ------------
>    31/12/1999
Wrong? should be month day year;
>
>       iso
>   ------------
>    1999-12-31
Right.
>
>      german
>   ------------
>    31.12.1999
Right.


Cheers,
Geoff Russell
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Fifth Ave           +618-8332-5069 (Home)          |
St Morris SA 5068     +618-8207-2029 (Work)          | geoff@austrics.com.au
Adelaide, AUSTRALIA   +618-8364-1543 (Fax-Home)      |


pgsql-general by date:

Previous
From: Bill Sofko
Date:
Subject: Re: That killer 3rd join...
Next
From: The Hermit Hacker
Date:
Subject: Re: That killer 3rd join...