Solved

What kind of time format is "00 61 1E 8F 78 BC C9 01" in hex?

Posted on 2009-04-13
5
291 Views
Last Modified: 2012-05-06
I'm reading in a registry key in my Windows Mobile device that has the value of the "PasswordSetTime" which I am assuming is the time the current device password was set, but I don't know how to convert this to human time.

When read in backwards, they convert to values that look like they mean something (It looks a bit like epoch if the last 8 digits are truncated) but I can't seem to figure it out. These values were retrieved between a few minutes.
00 61 1E 8F 78 BC C9 01 => reversed and converted to decimal => 128,841,290,340,000,000

00 99 8D 7A 77 BC C9 01 => reversed and converted to decimal => 128,841,285,700,000,000

Anyone know what these numbers mean and how I can get the date from them? Thanks for any help!
0
Comment
Question by:Kanivorous
  • 3
5 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 300 total points
ID: 24133295
Hello Kanivorous,
If you take the first 11 digits of the first of those numbers, i.e.
12,884,129,034
Then this would appear to be seconds from 1st January 1601
If you divide that number by 86400 (the number of seconds in a day) then you get this number
149,121.9
If you count days from 1st January 1601 (including leap days) then you get a date of 13th April 2009 at 20:43 (although you might need to adjust for time zones)
The 2nd time is therefore 464 seconds or 7:44 minutes earlier.
If you can determine the exact time for one then you should be able to get a fix on the others......
regards, barry
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 24133352
.....I gather that the above time would be UTC (co-ordinated universal time). Pacific time would be UTC -8 hrs, i.e. the time would adjust to 16:43 on 13th April 2009 with a possible further adjustment for daylight saving......
0
 
LVL 32

Assisted Solution

by:aleghart
aleghart earned 200 total points
ID: 24133663
Barry beat me to it.

http://support.microsoft.com/kb/188768

Must convert starting from nanoseconds.  Not easy to calculate because Excel treats any date before 1/1/1900 differently.  For instance, 1/1/1601 becomes 1/1/3501.

From: http://www.microsoft.com/technet/scriptcenter/topics/win2003/lastlogon.mspx
Note. In case youre wondering, a number of years ago the American National Standards Institute (ANSI) adopted a system of counting days; this system began with December 31, 1600 as Day 0. In turn, that made January 1, 1601 the first official day in history, with all subsequent dates and times being based on the number of nanoseconds elapsed since the 0 hour on January 1, 1601. (That day was a Monday, by the way.) These so-called ANSI decimal dates were originally designed for use with the COBOL programming language and have continued to be used by Windows and other operating systems.
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 24133838
....and just to correct an error in my second post.....
Of course if the UTC time/date is 13th April 2009 at 20:43 then UTC -8 is 12:43
regards, barry
0
 

Author Comment

by:Kanivorous
ID: 24134643
Thanks barry for the explanation and aleghart for the helpful links. That explanation in the link made my head spin and took a while to absorb.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exchange Server ActiveSync limit for Contacts 4 114
Pattern repeat for units digit of a base number 9 77
Auto Adjust Percent rate 5 62
SQLite with Mobile Development 4 46
Once again I push the limits of my phone.  An introduction to the Android Google Now Launcher.
Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question