Re: application displays date off by one day

Comments embedded.
On Jan 8, 10:33 am, kcu...@xxxxxxxxx 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
.

Relevant Pages

  • Re: Dates and time zones
    ... opening the Windows Explorer in other machine configured with different time zone. ... you want to display it. ... You also must think about the time zone if you store it in a database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: TimeZones - help wanted ... help needed ... desperate for help
    ... Would it work to simply display ... user will have to make adjustments for the time unless you have a field for ... each time zone and store the info for each time zone. ... What type of database are you using? ...
    (microsoft.public.dotnet.general)
  • Re: Calculating daylight saving time automatically
    ... You can either create a function in your database to calculate the correct adjusted time or a method in your application. ... I have to make a event signup page for our company that would display ... convert the inputed date from local time zone and convert it into UTC ...
    (microsoft.public.dotnet.general)
  • Re: Calculating daylight saving time automatically
    ... You can either create a function in your database to calculate the correct ... I have to make a event signup page for our company that would display ... convert the inputed date from local time zone and convert it into UTC ...
    (microsoft.public.dotnet.general)
  • Re: Greenwich Mean Time (GMT) in Microsoft Access 2003
    ... >in Microsoft Access 2003? ... The database has a form that is time sensitive. ... >appropriate record based on his time zone, ... Everyone's clock is set to different times, ...
    (comp.databases.ms-access)