Re: application displays date off by one day

Comments embedded.
On Jan 8, 10:33 am, kcu..._at_gmail.com wrote:
> > 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.)
>
> The problem only manifests itself in the display layer of the
> application.
>
> Database, Application , and Client (where problem is observed) are
> located
> in EST / America/New_York Time zone.
>
> Dates whose hour component is greater than 0100 hours display
> correctly.
>

I imagine the time component does not, as it's one hour behind New York time, thus making the suspect time zone setting CST.

> Dates whose hour component is between 0000 hours and 0100 hours
> display as the previous date, i.e. Date - one day.

No, it's still only ONE HOUR off. You're not looking at the complete picture.

>
>
>
> > > Value is stored as a Date.
>
> > It's not a date problem, it's a display issue.
>
> Agreed.
>
> KSC
David Fitzjarrell Received on Tue Jan 08 2008 - 11:52:54 CST