CODEWITHSUNDEEP
datelanguage-agnostic
David Murdoch
David Murdoch

Reputation: 89362

How can I convert a 5 digit int date and 7 digit int time to a real date?

I've come across some data where the date for today's value is 77026 and the time (as of a few minutes ago) is 4766011. FYI: today is Fri, 18 Nov 2011 12:54:46 -0600

I can't figure out how these represent a date/time, and there is no supporting documentation.

How can I convert these numbers to a date value?

Some other dates from today are:

77026 | 4765509
77026 | 4765003
77026 | 4714129
77026 | 4617107

And some dates from what is probably yesterday:

77025 | 6292509
77025 | 6238790
77025 | 4009544

Upvotes: 0

Views: 1503

Answers (1)

Marc B
Marc B

Reputation: 360792

Ok, with your expanded examples, it would appear the first number is a day count. That'd put this time system's epoch at

to_days(today) = 734824
734824 - 77025 = 657799
from_days(657799) = Dec 29, 1800

The time values are problematic, it looks like they're decreasing (unless you listed most recent first?), but if they are some "# of intervals since midnight", then centi-seconds could be likely. That'd give us a range of 0 - 8,640,000.

4765509 = 47655.09 seconds -> sec_to_time(47655) = 13:14:15
sec_to_time(47650.03) -> 13:14:10
sec_to_time(47141.29) -> 13:05:41
sec_to_time(46171.07) -> 12:49:31

Upvotes: 2

Related Questions