Bad date representation

From: Roland_DUBOULOZ <Roland(dot)Dubouloz(at)bull(dot)net>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Bad date representation
Date: 1999-07-09 09:25:13
Message-ID: 3785BFF9.B569809@bull.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Dubouloz(at)bull(dot)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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ansley, Michael 1999-07-09 09:59:34 RE: [SQL] Good Optimization
Previous Message Bruce Lowery 1999-07-09 07:08:18 uncorrelated subqueries