Re: Timestamps without time zone

Achilleas Mantzios wrote:

> Now instead of the above i tried something that should be "more" correct and
> according to specs
>     Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("UTC"));
>     st = con.prepareStatement("select
>         utcts,latid,longi,tracktrue,avgspeed,minspeed,maxspeed from gpscookeddata
>         where vslid=? and utcts<? and utcts>=? order by utcts");
>     st.setInt(1,Integer.parseInt(vslid));
>     st.setTimestamp(2,new java.sql.Timestamp(gendDate.getTime()),cal);
>     st.setTimestamp(3,new java.sql.Timestamp(gstartDate.getTime()),cal);
> however again i see that the JDBC insists producing code like:
>     select utcts,latid,longi,tracktrue,avgspeed,minspeed,maxspeed from
>     gpscookeddata where vslid=92 and utcts<'2006-03-26 07:00:00.000000+03' and
>     utcts>='2006-03-26 05:00:00.000000+03' order by utcts

This is unexpected - as you say the driver should generate timestamp
values in UTC if you pass a UTC calendar to setTimestamp.

Which driver version are you using?
How are you concluding that the JDBC driver is sending +03 values?

The driver will not generate a query string like you quoted above as it
uses parameter placeholders (assuming you are using protocol version 3
anyway) and sends the values out of line, which is why I'm asking.

-O