这是什么时间格式?(不是UNIX,UTC,没有什么)What time format is this? (not UNIX, not UTC, nothing)

- 此内容更新于:2014-12-30


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 1225295*XXX* 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.


(原文:What dates do those numbers represent?)


(原文:... not entirely sure, all we have is a data file dump. I thought this was some obscure time format, but other than swatch time or foreign keys (to a nonexistant table)... were stumped)


It's the number of minutes since midnight in five minute intervals. Your range of values should be 0 to 1440

斯沃琪的上网时间 一天分为1000个相等的部分。非常完全度量。

swatch internet time

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

Phill Sacre的回复:我想到这一点,但肯定没有人在世界上实际使用它吗?除了它没有日期信息:/

(原文:I thought about this, but surely no-one in the world actually uses it? Besides it has no date information :-/)

dove的回复:不要# 39;t错误低估别人

(原文:don't misunderestimate other people)

Greg的回复:还# 39;t听说斯沃琪网络一段时间!

(原文:Haven't heard about Swatch Internet Time in a while!)

Joe Pineda的回复:“斯沃琪互联网Time"只是decimalized时间,最初由法国革命者,重新定义与营销。它有一些优点巴比伦系统——那就快告诉我,如果一辆车是在恒定30公里/小时,它将在10秒多少距离?5分钟吗?1天?

(原文:"Swatch Internet Time" is just decimalized time, as originally redefined by the French Revolutionaries, with marketing. It has some advantages to the Babylonian system - tell me quickly, if a car goes at constant 30km/hr, how much distance will it go in 10 seconds? 5 minutes? 1 day?)

Joe Pineda的回复:只是为了完成我的晋升decimalized次30公里/小时= 72公里/ deciday。汽车旅行每milliday 720 /打(十分钟),72厘米/十进制。和每天720公里:D

(原文:Just for the sake of completing my promotion for decimalized time, 30km/hr = 72km/deciday. The car would travel 720m per milliday/beat (decimal minute), 72cm per decimal second. And 720km per day :D)


I've seen some systems where the date is stored in a special table and elsewhere as an id to it. This might be one of them


(原文:Good thought, but slightly suspicious they all end in 0 or 5... it is a tiny sample though...)

Vinko Vrsalovic的回复:系统日期存储在不同的表,很可能有id的结局只有在0或5,以防他们悄悄约会……,)

(原文:A system that stores dates in a different table, might very well have ids ending only in 0 or 5, in case they slipped a date... ;))

我认为你最好还是问原来的作者…… 或者,你可以插入到旧系统和出口日期吗? 如果你能做到这一点,那么你应该能够逆向工程很容易。

I think you'd be best off asking the original authors...

Alternatively, can you insert a date into the old system and export it? If you can do that then you should be able to reverse-engineer it very easily.


Here is the solution... thanks....


9:00:00 AM 540 9:15:00 AM 555 9:30:00 AM 570 9:45:00 AM 585 10:00:00 AM 600 10:15:00 AM 615 10:30:00 AM 630 10:45:00 AM 645 11:00:00 AM 660 11:15:00 AM 675 11:30:00 AM 690 11:45:00 AM 705 12:00:00 PM 720 12:15:00 PM 735 12:30:00 PM 750 12:45:00 PM 765 1:00:00 PM 780 1:15:00 PM 795 1:30:00 PM 810 1:45:00 PM 825 2:00:00 PM 840 2:15:00 PM 855 2:30:00 PM 870 2:45:00 PM 885 3:00:00 PM 900 3:15:00 PM 915 3:30:00 PM 930 3:45:00 PM 945 4:00:00 PM 960 4:15:00 PM 975 4:30:00 PM 990 4:45:00 PM 1005 5:00:00 PM 1020 5:15:00 PM 1035 5:30:00 PM 1050 5:45:00 PM 1065 6:00:00 PM 1080 6:15:00 PM 1095 6:30:00 PM 1110 6:45:00 PM 1125 7:00:00 PM 1140

Thomas Owens的回复:如果我可能会问,什么是算法用于生成这些值?

(原文:If I may ask, what algorithm is used to generate these values?)

Alex的回复:这# 39;午夜以来的分钟数:h * 60 + m(或(h + 12)* 60 +米,分次)。

(原文:It's just the number of minutes since midnight: h * 60 + m (or (h+12) * 60 + m, for PM times).)

他们应该代表日期或时间吗?如果日期,那么他们很可能只是一个偏移量从一个众所周知的时代(像time_t秒从1 - 1月- 70)。 如果你没有文档以查找你需要的时代工作从一个例子。

Are they are supposed to represent dates or times? If dates, then they are probably just an offset from a 'well known' epoch (like time_t are seconds from 1-Jan-70).

If you don't have documentation to find the epoch you'll need an example to work it out from.


This represent time, no date. And the same code-time appear in different date.

有时你可以看到10/10/2005 880。第一部分表示日期和第二个,必须代表在这一天的时间。

(原文:Some times you can see 10/10/2005 880. The first part represent the date and the second one, must represent the time in this day.)


could be a julian date...?


There is no way to know for sure. I could be beats, but then again, it might not be.

cfeduke的回复:要是有+ 1有趣的评级!

(原文:If only there was +1 funny rating!)