Bad date representation
От | Roland_DUBOULOZ |
---|---|
Тема | Bad date representation |
Дата | |
Msg-id | 3785BFF9.B569809@bull.net обсуждение исходный текст |
Ответы |
Re: [SQL] Bad date representation
|
Список | 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 по дате отправления: