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