+ Reply to Thread
Results 1 to 3 of 3

Date to Unix time stamp?

  1. #1
    Newbie
    Guest

    Date to Unix time stamp?

    I have dates that I need to convert to a Unix timestamp.

    Ex:
    Date: October 20, 2003
    Unix time stamp: 1066460400



  2. #2
    JE McGimpsey
    Guest

    Re: Date to Unix time stamp?

    Unix timestamps are the number of seconds after 1/1/1970 00:00:00, so

    A1: 10/20/2003
    A2: =(A1-DATE(1970,1,1))*86400 ===> 1066608000


    Note that your example would be incorrect:

    B1: 1066460400
    B2: =DATE(1970,1,1) + B1/86400 ===> 10/18/2003 07:00:00

    not 10/20/2003



    In article <[email protected]>,
    "Newbie" <[email protected]> wrote:

    > I have dates that I need to convert to a Unix timestamp.
    >
    > Ex:
    > Date: October 20, 2003
    > Unix time stamp: 1066460400


  3. #3
    Newbie
    Guest

    Re: Date to Unix time stamp?

    Thank you for this info!!!!!

    I have converted all my dates!
    "JE McGimpsey" <[email protected]> wrote in message
    news:[email protected]...
    > Unix timestamps are the number of seconds after 1/1/1970 00:00:00, so
    >
    > A1: 10/20/2003
    > A2: =(A1-DATE(1970,1,1))*86400 ===> 1066608000
    >
    >
    > Note that your example would be incorrect:
    >
    > B1: 1066460400
    > B2: =DATE(1970,1,1) + B1/86400 ===> 10/18/2003 07:00:00
    >
    > not 10/20/2003
    >
    >
    >
    > In article <[email protected]>,
    > "Newbie" <[email protected]> wrote:
    >
    >> I have dates that I need to convert to a Unix timestamp.
    >>
    >> Ex:
    >> Date: October 20, 2003
    >> Unix time stamp: 1066460400




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1