Horton

Thread

  1. TIMESTAMP('now') y2k bug

    Dan Linderman <linderdm@ironhilltechnology.com> — 2000-01-06T19:35:48Z

    Your name  : Dan Linderman
Your email address : linderdm@ironhilltech.com


System Configuration
---------------------
  Architecture (example: Intel Pentium)   : Intel Pentium III 500mhz

  Operating System (example: Linux 2.0.26 ELF)  : Redhat LINUX 6.0

  PostgreSQL version (example: PostgreSQL-6.5.3):   PostgreSQL-6.5.3

  Compiler used (example:  gcc 2.8.0)  : ?


Please enter a FULL description of your problem:
------------------------------------------------
When I insert a timestamp using the TIMESTAMP('now') into a date field,
"1999-12-31 19:00:00-05" is what is inserted into the field.  This has been
done on multiple machines with PostgreSQL-6.5.3, and has been used when
inserting into a timestamp field, and a datetime field.




Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Create a table with a date field.  Insert TIMESTAMP('now') into that field.
Select that row to see bug.



Dan Linderman
Web Programmer
Iron Hill Technology
linderdm@ironhilltech.com
302-369-9750 x23
www.ironhilltech.com