Skip site navigation (1) Skip section navigation (2)

Bug with NOW

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 (view raw or flat)
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



pgsql-bugs by date

Next:From: Krzysztof CzumaDate: 1999-10-02 23:17:49
Subject:
Previous:From: lad101880 lad101880 ghzhDate: 1999-10-02 07:56:21
Subject: WANNA ENTER UR SOCIETY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group