Hi all,
I am testing Postgres 8.0.0 beta4 on Windows 2000. I checked the changelog
but could not find a corresponding topic.
I am facing a time problem with timestamp handling. Here is what I did: I
insert data via JDBC. The timestamp value in the prepared statement is still
'2003-08-19 11:40:08.0' as the debugger (of Eclipse) confirms. Inserted in
the database gets a tiemstamp 2003-08-19 09:40:08.0'. CURRENT_TIME of
DB-Server is an hour back to server time.
Before I do the insert I do a select to check if such data is already in the
DB. The select does not change the timestamp - so program goes in insert
method.
I used the JDBC-Driver pg80b1.308.jdbc3.jar coming with the German
postgresql-8.0.0-beta4.msi
Windows says RevisionNo: {6ABA084E-D3FB-4253-95FF-68A0A066F69B}, if that is
of any help?
Today I tried my program using the JDBC-Driver of Postgres 7.4.6
(pg74.215.jdbc3.jar). With that JDBC- driver everything works fine. Is there
any parameter I missed to set in version 8, or is it a bug?
Regards,
Antje Stejskal