| From: | Eliézer Madeira de Campos <eliezer(at)diuno(dot)com(dot)br> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Missing seconds in a date (timestamp) |
| Date: | 2005-11-04 17:42:04 |
| Message-ID: | 54CC7CADE26E884EB2BCEC863F5C1F70F9D255@moscou.diuno.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Any ideas?
Eliézer Madeira de Campos
eliezer (at) diuno.com.br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2005-11-04 17:46:02 | Re: Division |
| Previous Message | Tino Wildenhain | 2005-11-04 17:39:24 | Re: Division |