Postgres Pro
Downloads
Home   >   mailing lists

Missing seconds in a date (timestamp) - Mailing list pgsql-bugs

From Eliézer Madeira de Campos
Subject Missing seconds in a date (timestamp)
Date
Msg-id 54CC7CADE26E884EB2BCEC863F5C1F70F9D25F@moscou.diuno.net
Whole thread Raw
List pgsql-bugs
Tree view
Hello everyone:
 
I'm working to upgrade a database from PostgreSQL 7.3 to 8.0 version.
The database serves a complex J2EE application, running Jboss in multiple servers. All servers run Linux RedHat.
I found a problem yesterday.
Whenever the application inserts a date prior to 1914-01-01, the actual date written in the database is different. For instance:
'1900-01-01' is stored as '1899-12-31 23:59:32'. The column datatype is timestamp without timezone.
 
If I run the command directly against the database (psql) the date is stored correctly. The weird thing is that we tried to debug the JDBC driver and it seems to be sending the correct information to the database.
 
I couldn't find any report on this... so I guess it is most likely I'm doing something wrong.
 
Any ideas?

Eliézer Madeira de Campos
eliezer (at) diuno.com.br

pgsql-bugs by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: how to install postgres 8.0.4 in RHEL4
Next
From: elein
Date:
Subject: Re: attislocal value changed with the dump