Re: Timestamp

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: Alex Falkowski <alex(at)l-o-u-d(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Timestamp
Date: 2002-06-25 01:29:32
Message-ID: 1024968573.2087.49.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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
>

In response to

  • Timestamp at 2002-06-24 01:09:44 from Alex Falkowski

Browse pgsql-jdbc by date

  From Date Subject
Next Message John Hicks 2002-06-25 06:24:14 Re: servlets and JDBC (postgresql 7.2)
Previous Message Tom Lane 2002-06-25 01:21:29 Re: Timestamp