[Pljava-dev] problem with date and timezone

From: Eric(dot)Boyer at insa-toulouse(dot)fr (Eric BOYER)
To:
Subject: [Pljava-dev] problem with date and timezone
Date: 2008-11-24 16:06:51
Message-ID: 492AD11B.3060405@insa-toulouse.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Hello,

When I set a date in a row, this row is OK but the trigger seems not to
be in the same timezone because I have one day less (in reality one hour).

I use Debian :
aladin at srv-aladin:/usr/local/aladin$ more /etc/timezone
Europe/Paris

My JVM tell me : System.out.println(TimeZone.getDefault());
sun.util.calendar.ZoneInfo[id="GMT+01:00",offset=3600000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]

And the trigger :
sun.util.calendar.ZoneInfo[id="GMT+01:00",offset=3600000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]

So that's the same ...

On another server, all is OK but with the same localtime !!! :
boyere at footcrix:~/INSA/documents/foot$ more /etc/timezone
Europe/Paris

My JVM and Triiger client tell me :
System.out.println(TimeZone.getDefault());
sun.util.calendar.ZoneInfo[id="Europe/Paris",offset=3600000,dstSavings=3600000,useDaylight=true,transitions=184,lastRule=java.util.SimpleTimeZone[id=Europe/Paris,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode=2]]

So what could be is wrong in my first server ?

I use postgresql 8.1 and the same pljava version (I think 1.3 ...).

thanks for your Help,

Eric

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Kris Jurka 2008-11-24 16:33:36 [Pljava-dev] problem with date and timezone
Previous Message Imre Oolberg 2008-11-23 18:07:27 [Pljava-dev] calling pljava function seems to change locale settings