这是什么时间格式?(不是UNIX,UTC,没有什么)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 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.
(原文：What dates do those numbers represent?)mauriciopastrana的回复:…不完全肯定的是,我们有一个数据文件转储。我认为这是一些模糊的时间格式,但是除了斯沃琪时间或外键(nonexistant表)…被难住了
(原文：... 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
day is divided into 1,000 equal parts. very metric altogether.
(原文：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
(原文：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.
(原文：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.
(原文：If only there was +1 funny rating!)
- 在MySQL中变量限制条款Variable LIMIT Clause in MySQL
- 从MySQL在Java中检索记录Retrieving records from MySQL in Java
- mysql导入脚本mysql import script
- 有什么问题这个create table语句(复制)What is wrong with this create table statement [duplicate]
- 是什么数据类型使用散列密码字段长度呢?What data type to use for hashed password field and what length?
- 这是什么时间格式?(不是UNIX,UTC,没有什么)What time format is this? (not UNIX, not UTC, nothing)
- 通过cli从远程mysql导入sql服务器mysql import sql via cli from remote server
- 最好的货币MySQL数据类型是什么?What is the best datatype for currencies in MySQL?
- 编写一个单元测试框架,测试SQL存储过程Writing a unit testing framework for testing SQL stored procedures
- 我怎么能在MySQL在两列布尔逻辑吗?How can I do boolean logic on two columns in MySQL?
- 我怎么做布尔逻辑在MySql的两列,其中一个是一个Varchar吗?How do I do boolean logic on two columns in MySql, one of which is a Varchar?