Bug with NOW
От | Gena Gurchonok |
---|---|
Тема | Bug with NOW |
Дата | |
Msg-id | 14788.991002@rt.mipt.ru обсуждение исходный текст |
Список | pgsql-bugs |
Hello. ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Gena Gurchonok Your email address : gena@rt.mipt.ru System Configuration--------------------- Architecture : Operating System : Linux 2.2.9 ELF PostgreSQL version : PostgreSQL-6.5 Compiler used : pgcc-2.91.66 19990314 (egcs-1.1.2 release) Please enter a FULL description of your problem: There was one moment when action like this cause fun error. 'now' returned value : "Fri 01 Oct 13:35:60.00 1999 MSD" Note that trying to use this string to COMPARE with DATETIME field cause PSQL error - Bad datetime external representation ------------------------------------------------ Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: INSERT INTO mytable (field_datetime) VALUES('now'); do this often and you can obtain such result. Gena
В списке pgsql-bugs по дате отправления: