From: | carapuz at gmail(dot)com (Nic Nofamily) |
---|---|
To: | |
Subject: | [Pljava-dev] Has ResultSet.getDate() correct handling DayLight saving time? |
Date: | 2006-03-30 20:04:42 |
Message-ID: | ce6becd90603301204p4ad121dcna667b89621661b17@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hi all!
I have a little trouble with my pljava functions last night:(
--------------
here config:
Java HotSpot(TM) Server VM (build 1.5.0_06-b05, mixed mode)
Debian Sarge
pljava 1.2.0 compiled from source
postgresql 8.1.3 installed from debian backports
---------------
ResultSet.getDate for to_date('01/11/2005','DD/MM/YYYY') returns
31/10/2005 for pljava jdbc driver
the same java code using postgresql jdbc driver works fine:(
I discovered that wrong result depend on DayLight Saving time
and i wrote workaround on ObjectResultSet.getDate()
public Date getDate(int columnIndex)
throws SQLException
{
Date d = (Date)this.getValue(columnIndex,Date.class);
if(!java.util.TimeZone.getDefault().inDaylightTime(d)){
d = new
java.sql.Date(d.getTime()+java.util.TimeZone.getDefault().getDSTSavings());
}
return d;
}
now my pljava code works good, but that's wrong way:(
What are you comments, developers?:)
PS: sorry for my English,I am Russian:)
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2006-03-30 20:54:45 | [Pljava-dev] Has ResultSet.getDate() correct handling DayLight saving time? |
Previous Message | Thomas Hallgren | 2006-03-30 19:23:29 | [Pljava-dev] ERROR: Unable to find static method Active.executeService with signature (Ljava/lang/Integer; Ljava/lang/String; Ljava/lang/Integer; )I |