Alex,
I don't see anything wrong in what you have shown here. You must
understand that Timestamp.toString() prints out the timestamp in the
local timezone. You will see that the PreparedStatement is using the
GMT timezone (i.e. +00). Thus these two are identical (assuming your
local timezone is GMT-10).
thanks,
--Barry
Alex Falkowski wrote:
> 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