Re: application displays date off by one day
Date: Tue, 8 Jan 2008 09:52:54 -0800 (PST)
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
> Database, Application , and Client (where problem is observed) are
> in EST / America/New_York Time zone.
> Dates whose hour component is greater than 0100 hours display
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.
David Fitzjarrell Received on Tue Jan 08 2008 - 11:52:54 CST