in reply to Goofy Date and Time Think

It looks like your dealing with Microsoft FILETIME stamps in nanoseconds since 1/1/1601.

If you pass the hi and lo parts into the following sub it will return a unix-style timestamp in seconds. 

sub filetimeToUnix{
    my ( $hi, $lo ) = @_;
    my $nanosecs =  $hi * 2**32 + $lo;
    return int( ($nanosecs - 116444736010000000) / 1E7 );
}

[download]
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.

Replies are listed 'Best First'.
Re^2: Goofy Date and Time Think
by nanojack (Initiate) on Dec 21, 2005 at 20:25 UTC
    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?
[reply]

      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

      [download]
      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.
[reply]
[d/l]
        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?
[reply]
Re^2: Goofy Date and Time Think
by nanojack (Initiate) on Dec 21, 2005 at 20:16 UTC
    is 116444736010000000 the nanoseconds of 1/1/1601?
    I am not sure what the output is.
    nanojack
    -How important does a person have to be before they are considered assassinated instead of just murdered?
[reply]

In Section Seekers of Perl Wisdom