From: | Gena Gurchonok <gena(at)rt(dot)mipt(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug with NOW |
Date: | 1999-10-02 14:55:05 |
Message-ID: | 14788.991002@rt.mipt.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello.
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Gena Gurchonok
Your email address : gena(at)rt(dot)mipt(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Krzysztof Czuma | 1999-10-02 23:17:49 | |
Previous Message | lad101880 lad101880 ghzh | 1999-10-02 07:56:21 | WANNA ENTER UR SOCIETY |