datestyle problems?

It was called out in the release notes for 7.0*

I got burned too...

Larry
* Geoff Russell <geoff@austrics.com.au> [000906 22:07]:

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) |

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749