Bug with NOW

Started by Gena Gurchonokover 26 years ago1 messagesbugs
Jump to latest
#1Gena Gurchonok
gena@rt.mipt.ru

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