Re: application displays date off by one day
Date: Tue, 8 Jan 2008 08:07:33 -0800 (PST)
Message-ID: <03a97ef5-2e05-45f0-9ab7-214b756849a5@e10g2000prf.googlegroups.com>
Comments embedded.
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.
>
Define 'incorrectly'.
> This seems to be related to some Time Zone setting.
Depending upon the output that could be a reasonable assumption.
>
> 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.
And is this on the client, the server, both? Which time zone are you in? (We know, from your posts, that the database believes it's in New York.)
>
> Value is stored as a Date.
It's not a date problem, it's a display issue.
>
> Any suggestions?
>
> KSC
David Fitzjarrell
Received on Tue Jan 08 2008 - 10:07:33 CST