Join 3,430 readers in helping fund MetaFilter (Hide)

Tags:

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 [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


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


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


« Older I often find, when I go to buy...   |  Looking for something in betwe... Newer »

You are not logged in, either login or create an account to post comments