Skip to main content
Participant
Sep 27, 2006 4:15 PM UTC
Question

Convert number of seconds since January 1, 1970 00:00:00 (epoch time) to a datetime format



I have a code that should convert number of seconds since January 1, 1970 00:00:00 (epoch time) to
a datetime format. It uses something like the following:

DateAdd("s",mydateinsecs,CreateDateTime(1970,1,1))

The problem is if the date is in DST (daylight savings time), 1 extra hour will be added to the resulting time by DateAdd().

Does someone how to fix it?
    This topic is closed to new replies. Start a new post to keep the conversation going.

    1 reply

    Inspiring
    Sep 27, 2006 4:36 PM UTC
    VictorSotnikov wrote:
    > The problem is if the date is in DST (daylight savings time), 1 extra hour
    > will be added to the resulting time by DateAdd().


    http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=77223B6A-20ED-7DEE-2AB7FBB1F37ABD77
    Translate