Skip to main content
Software Engineering

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

8
  • 3
    To the close-voters: I think this is one of the rare questions that could be a "how do I write this code" question, but there does exist I real conceptual answer. Commented Oct 30, 2022 at 16:20
  • When you say you tried the epoch method, does that include an alternate time 0, and alternate resolution? Commented Oct 30, 2022 at 17:03
  • The numbers are double precision, counting days since Jan 1st 1900. Commented Oct 30, 2022 at 21:22
  • The day count on Jan 1st 2,000 is 36523, so apparently the base is midnight Jan 1st or start of day Jan 2nd 1900. Commented Oct 30, 2022 at 21:28
  • There aren't a wide enough range of dates and times. A whole day appears to be a value of 2 00 00 00 00, suggesting that a 12 hour period is fundamental. The difference between 3/1/2000 and 3/1/2001 is 2D A0 00 00 00 00, where 2DA is 730, which is 2*365. I suspect also the highest components are not part of a day count. It also seems clear that the 4 lower bytes are exclusively a time component. Commented Oct 30, 2022 at 22:26