Re: Timestamp

You may want to try the dev driver. Any modifications between releases
will be built into that jar, as opposed to the release jar

Dave
On Sun, 2002-06-23 at 21:09, 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
>