Search Postgresql Archives

Re: Problem with Timestamp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hi,
though i dont use JDBC, i was just interested and found some links (which may be helpful) ...

http://archives.postgresql.org/pgsql-bugs/2004-02/msg00028.php

http://72.14.203.104/search?q=cache:ptQFfXTM0pgJ:snaga.org/pgsql/cvsweb.cgi/pgsql/src/interfaces/jdbc/org/postgresql/test/jdbc2/TimestampTest.java%3Frev%3D1.1.1.2+postgres+getTimestamp(+time+zone&hl=en&client=firefox-a

http://www.nabble.com/Re:-Timestamp-Conversion-Woes-Redux-p460930.html

thanks,
vish

On 1/18/06, boff <bglauber@xxxxxxxxx> wrote:

Hi.. I'm having some problems with Timestamp.
 
I have a TIMESTAMP WITH TIME ZONE field called 'time' in my table. The value of this field will be given by the "java.sql.Timestamp" in my application.
When I store this value in the table it's correct, but when I make a SELECT in this field and take it using the getTimestamp( ) method from JAVA, the value wich is returned is not that one which is stored in the database: the value which is returned does not contain the timezone code. So, I can't use this value, which is incorrect. It can be any conversion of types, I think.
 
I thought it could be any problem with JDBC, but I put the last version and nothing has changed.
 
What could it be?? I've spent hours looking for anything that could help me but I haven't found.
 
 
Thanks
Glauber


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux