Bad date representation - Mailing list pgsql-sql

From Roland_DUBOULOZ
Subject Bad date representation
Date
Msg-id 3785BFF9.B569809@bull.net
Whole thread Raw
Responses Re: [SQL] Bad date representation  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-sql
Is there a bug in the postmaster ?
with -e option the date must be in European format
but with no options the date may be in European or American format !

create table FOO (date date);

1.- postmaster -i -o -e 
 insert into FOO values('20-06-1999');  insert into FOO values('06-21-1999'); we have a "Bad date external
representation"that is true.
 

2.-postmaster -i
 insert into FOO values('06-22-1999'); insert into FOO values('06-07-1999'); insert into FOO values('23-06-1999');
<----no ERROR  WE Have NO ERROR !!!!! why ???
 

and on select * from FOO the result is 
date ---------- 06-22-1999 06-07-1999 06-23-1999



-- 
Roland Dubouloz            BULL XS/BU
BULL SA                mailto:Roland.Dubouloz@bull.net
1,Rue de Provence        Phone :+33 (0)4 76 29 77 87
BP 208                Bullcom : 229-7787
38432 Echirolles CEDEX        Office  : A1-052
France                Fax     : +33 (0)4 76 29 70 02


pgsql-sql by date:

Previous
From: "Anna Langer"
Date:
Subject:
Next
From: "Ansley, Michael"
Date:
Subject: RE: [SQL] Good Optimization