Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What time format is this? (not UNIX, not UTC, nothing)

I'm importing data from another system to MySQL, its a CSV file. The "Date" field however contains cryptic of 3-digit time entries, here's a random sample set:

> 540
> 780
> 620
> 965

What's this? obviously its not 5:40 and 6:20. But it's not UNIX either (I tried 1225295XXX before I realized the time range this represents is about 16 minutes)

Anyone recognize these?

Update: I just noticed that further down in the replies, a coworker who's closer to the data just opened a new SO account and added some more data. It seems like these numeric entries are just time entries (not date). Still clueless.

IMHO, if no one can recognise this, then it probably isn't some (if obscure) standard time format and is more likely that these entries are foreign keys.

Update 2: Many thanks to all! we found the answer visually, but as usual, SO pulled through clutch.

like image 935
mauriciopastrana Avatar asked Oct 29 '08 15:10

mauriciopastrana


1 Answers

swatch internet time

day is divided into 1,000 equal parts. very metric altogether.

like image 61
dove Avatar answered Sep 28 '22 02:09

dove