in reply to Re: Goofy Date and Time Think
in thread Goofy Date and Time Think

What I ment to say is I have this product let's say it is 1134744389.41727. I think that is is seconds, but from when? That is what I ment to say. Do I add this back into 1/1/1601 and if so how can I convert 1/1/1601.

Thanks for the help
-How important does a person have to be before they are considered assassinated instead of just murdered?

Replies are listed 'Best First'.
Re^3: Goofy Date and Time Think
by BrowserUk (Patriarch) on Dec 21, 2005 at 21:46 UTC

    MS timestamps are 100 nanosecond units (1e-7) since 1 Jan, 1601.

    Unix timestamps are seconds (plus decimals?) since 1 Jan 1970.

    So to convert Unix style to MS, you add 11644473600 and multiply by 1e7.

    To go the other way you divide by 1e7, subtract 11644473600, and truncate to an integer.

    Where does the value, 1134744389.41727 come from? and what do you want to do with it?

    It appears to be a unix timestamp from a few days ago:

    print scalar localtime 1134744389.41727;; Fri Dec 16 14:46:29 2005

    Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
    Lingua non convalesco, consenesco et abolesco. -- Rule 1 has a caveat! -- Who broke the cabal?
    "Science is about questioning the status quo. Questioning authority".
    In the absence of evidence, opinion is indistinguishable from prejudice.
      You Rock!!! I just learn a lot of stuff here.
      Thanks
      -How important does a person have to be before they are considered assassinated instead of just murdered?