Timestamp - Mailing list pgsql-jdbc

From Alex Falkowski
Subject Timestamp
Date
Msg-id 002b01c21b1b$d3865ba0$0dfda8c0@wsalex
Whole thread Raw
Responses Re: Timestamp
Re: Timestamp
List pgsql-jdbc
I read your latest java/JDBC news and i saw that you fixed the timestamp problem, yet when i install the new jar files an run this code
 
DataSource d = (DataSource) new InitialContext().lookup("java:comp/env/jdbc/macquarie_awards");
 
 java.sql.Connection conn = d.getConnection();
 
 out.println(conn.getMetaData().getDriverVersion() + "<BR>");
        java.sql.PreparedStatement pstmt;
        pstmt = conn.prepareStatement("SELECT o.id FROM question o WHERE (o.question_date = ?)");
        pstmt.setTimestamp(1, new java.sql.Timestamp(1024668000000L));
       
        out.println(new java.sql.Timestamp(1024668000000L) + "<BR>");
        out.println(pstmt + "<BR>");
 
I get the following output, which clearly marks to me that setTimestamp is doing something wrong
 
PostgreSQL 7.2 JDBC2
2002-06-22 00:00:00.0
SELECT o.id FROM question o WHERE (o.question_date = '2002-06-21 14:00:00.00+00')
 
Is this being fixed, cause my EJB are not returning the right values cause of this

pgsql-jdbc by date:

Previous
From: tony
Date:
Subject: Re: How can I stop a long running query
Next
From: Dave Cramer
Date:
Subject: Re: Timestamp