Re: application displays date off by one day
From: <kcurry_at_gmail.com>
Date: Tue, 8 Jan 2008 08:33:21 -0800 (PST)
Message-ID: <e1c289d5-3220-4e71-88c8-03d9289de9d2@i3g2000hsf.googlegroups.com>
Date: Tue, 8 Jan 2008 08:33:21 -0800 (PST)
Message-ID: <e1c289d5-3220-4e71-88c8-03d9289de9d2@i3g2000hsf.googlegroups.com>
> 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.
Dates whose hour component is between 0000 hours and 0100 hours display as the previous date, i.e. Date - one day.
>
> > Value is stored as a Date.
>
> It's not a date problem, it's a display issue.
>
Agreed.
KSC Received on Tue Jan 08 2008 - 10:33:21 CST