Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Unix Epoch conversion (Access 2000)

    This is really odd. If you can figure this out consider yourself awesome.

    I'm trying in access 2000 to convert a unix epoch date to a regular readable date format. Example: 1037915399 = unix date value this value is how many seconds the record was created since Jan. 1, 1970. I need to figure what is the date representation for the example. If you figure this out can you show me how? Anybody ever do this before? I'm clueless.. Thanks...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Unix Epoch conversion (Access 2000)

    Say that your Unix Epoch dates are in a field UnixDate. The followin expression will convert this to a date as used by Windows (and Access):


    (if you want to use it as control source of a text box, place an = sign before the expression)

    Explanation: divide the Unix date by the number of seconds in a day (24 * 60 * 60 = 86,400) to convert to the number of days since the start of 1/1/1970. Add the value Windows uses for 1/1/1970 to convert this to a Windows date, i.e. the number of days since12/31/1899.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts