Re: Calculating daylight saving time automatically

Tech-Archive recommends: Fix windows errors by optimizing your registry

I had a similiar situation at my last job.

Check http://en.wikipedia.org/wiki/Daylight_saving_time for more information to get you started.
You can either create a function in your database to calculate the correct adjusted time or a method in your application.

Hello mazdotnet,

Hi guys,

I have to make a event signup page for our company that would display
the event time/date in 3 different time zones (Eastern - New York,
Central - Chicago, and Pacific - San Francisco). To do this. I
convert the inputed date from local time zone and convert it into UTC
and store it in the database (correct me if I'm wrong please). Next to
display it I would add the correct time zone difference value (-5 for
Eastern). How to do I handle the daylight saving time though? For
example the -5 Eastern time is right now -4. Is there a way to do this
automatically? Any samples would be greatly appreciated.

Thanks
M.


.

Relevant Pages

  • Re: application displays date off by one day
    ... The problem only manifests itself in the display layer of the ... Database, Application, and Client are ... York time, thus making the suspect time zone setting CST. ...
    (comp.databases.oracle.server)
  • 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: 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)
  • 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: Time displayed on GPS
    ... >>approximation of time zone boundaries, ... You just need something like the unix tz database, ... Indiana has three different situations. ... 11 counties -- six near Chicago, IL, and five near ...
    (sci.geo.satellite-nav)