What format is this timestamp: 2456799.87848174 ?
May 24, 2014 9:38 AM   Subscribe

I have an excel sheet of data extracted from a SQL database. A column in the table is headed "time" and has the following format: 2456799.87848174. How do I convert this to a human readable date and time, or even a unix timestamp?

I think the following match, very roughly, to these dates and times if it helps

22/5/14 - 0900: 2456799.87848174
22/5/14 - 1000: 2456799.89098252
22/5/14 - 1100: 2456799.90347924
22/5/14 - 1200: 2456799.92431562
posted by Morsey to Computers & Internet (4 answers total) 2 users marked this as a favorite
These appear to be in Julian Day Format, possibly from SQLite.
posted by bottlebrushtree at 9:50 AM on May 24, 2014 [1 favorite]

Here is an online Julian Date converter, put the long number in the Julian date field and click Calculate.
posted by bottlebrushtree at 9:55 AM on May 24, 2014

Brilliant, the converter is exactly what I needed - Thank you :)
posted by Morsey at 10:07 AM on May 24, 2014

Inside Excel, =cell-2415018.5 and format as date/time gives you the timestamp.
posted by effbot at 10:40 AM on May 24, 2014 [1 favorite]

« Older Where to buy ebooks other than Amazon?   |   What do you wear to dress up if you're androgynous... Newer »
This thread is closed to new comments.