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