Re: application displays date off by one day

On Jan 7, 12:04 pm, "allen.dar..._at_gmail.com" <allen.dar..._at_gmail.com> wrote:
> On Jan 7, 10:51 am, kcu..._at_gmail.com wrote:
>
> > I have an application developed in JDeveloper 10.1.2.1.0 that is
> > displaying dates incorrectly.
>
> > This seems to be related to some Time Zone setting.
>
> > If the date is 2006-03-20 00:00:00.0 is displays as 2006-03-19.
>
> > If the date is 2006-03-20 01:01:00.0 is displays as 2006-03-20.
>
> > Value is stored as a Date.
>
> > Any suggestions?
>
> > KSC
>
> Can you query a table and see what time zone setting you are in?

From SQL:

select current_timestamp from dual

> 2008-1-7 13.40.xx.xxxxxx America/New York

select dbtimezone from dual

> EST
From Java:

Date = Monday Jan 07 13:40:xx EST 2008

> at 13:53

Calendar = java.util.GregorianCalendar
[
time=1199732965985,
areFieldsSet=true,
lenient=true,
zone=sun.util.calendar.ZineInfo[

id="America/New_York",
offset=-18000000,
dstSavings=3600000,
useDaylight=true,
transition=235,
lastRule=java.tuil.SimpleTimeZone[
id="America/New_York",
offset=-18000000,
dstSavings=3600000,
useDaylight=true,
startYear=0,
startMode=3,
startMonth=3,
startDay=1,
startDayofWeek=1,
startTime=7200000,
startTimeMode=0,
endMode=2,
endMonth=9,
endDay=1,
endDayofWeek=1,
endTime=7200000,
endTimeMode=0,}},
firstDayofWeek=1,
minimalDaysinFirstWeek=1,
ERA=1,
YEAR=2008,
MONTH=0
WEEK_OF_YEAR=2,
WEEK_OF_MONTH=2,

DAY_OF_MONTH=7,
DAY_OF_YEAR=7,
DAY_OF_WEEK=2,
DAY_OF_WEEK_IN_MONTH=1,