Storing Date/Time with Daylight savings

From: Lourenço Teodoro (lourenco_xxi_at_hotmail.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 12:38:43 -0500

Dear All,

I am developing an application that will save historical data; The table is
very simple, it will have a Time Stamp column and other columns to save real
values. The application should be able to work with several different
databases. My problem now is to make a decision about the date/time to be
saved in the Time Stamp; I can use either System Time (GMT) or Local Time;
if I choose the first one, the users will get confused when they try to open
the tables using a GUI other than mine. On the other hand, if I save using
Local Time, I can have problems with Daylight saving. Does anyone have any
idea about how to avoid problems with daylight saving other than saving the
System Time?

Note: I thought about using an additional field (maybe save both, System
Time and Local Time), but I think that you experts should have a better
solution.

Thank you in advance,
Lourenço.

Relevant Pages

  • Re: fsck died with nexit status 8
    ... time of install the system clock is not set in some distros or your ... local time gets set as EST which means that at next boot in terms ... behaving presumably because your local time stamp is now atleast equal ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: File Date and Time stamp after FileStream.Write(), C#
    ... running app tests on my Dell Axim Pocket PC device, ... It has been the memory card installation that has been the change and is ... where I noticed the time stamp differences. ... in device memory uses local time. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: subtract 1 day
    ... time stamp and the result is 23 hours earlier, ... Start with a unix ... I had the same effect when clocks were turned +1 hour to daylight saving ...
    (comp.lang.php)
  • Re: File Date and Time stamp after FileStream.Write(), C#
    ... newly created files had the time stamp of the local time. ... I have just noticed in my CF app on a Pocket PC (PPC) that when I create ... stamp displayed in the Modified column in Windows Explorer on the ...
    (microsoft.public.dotnet.framework.compactframework)
  • convert time string in UTC to time in local time
    ... This was working fine now, but if I do it for a date next week, it breaks because my local time moves to daylight savings time this weekend. ... I'm guessing if I try this next week it will work okay because time.timezone will be give a different value next week - is that correct? ... Is there a direct way to convert that timestamp in UTC to a local time stamp that will always work? ...
    (comp.lang.python)