how to convert to standard date and time

Question

Ruben Llamas 2012-7-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42939-how-to-convert-to-standard-date-and-time

HELLO...

I am using a sensor to collect some data and the data file output is giving me the date and time as follows:

1.37303200000000 1.38359200000000 1.39406100000000 1.40446400000000 1.41493300000000 1.42549300000000 1.43596200000000 1.44643200000000 1.35280200000000 1.36327200000000 1.37383200000000 1.38423400000000 1.39470400000000 1.40517300000000 1.41573300000000 1.42620200000000 1.43667200000000 1.60434400000000 1.61490400000000 1.62530600000000 1.63577600000000 1.64624500000000 1.65680500000000 1.66727400000000 1.67774400000000 1.68814600000000 1.69870600000000 1.70917600000000 1.71964500000000 1.73011400000000 1.74067400000000 1.75107700000000 1.76154600000000 1.77201600000000 1.78257600000000 1.79304500000000 1.80351400000000 1.81400800000000 1.82447700000000 1.83494600000000 1.84541600000000 1.85597600000000 1.86644500000000 1.87684800000000 1.88731700000000 1.89787700000000 1.90834600000000 1.91881600000000 1.92928500000000 1.93977800000000 1.95024800000000 1.96071700000000 1.97118600000000 1.98174600000000 1.99221600000000 2.00319400000000 2.01366400000000 2.02422400000000 2.03469300000000 2.04516200000000 2.05565600000000 2.06612500000000 2.07659400000000 2.08706400000000 2.09762400000000 2.10809300000000 2.11849600000000 2.12896500000000 2.13952500000000 2.14999400000000 2.16046400000000 2.17093300000000 2.18142600000000 2.19189600000000 2.20236500000000 2.21283400000000 2.22339400000000 2.23386400000000 2.24426600000000 2.25473600000000 2.26529600000000 2.27576500000000 2.28623400000000 2.29672800000000 2.30719700000000 2.31766600000000 2.32813600000000 2.33869600000000 2.34916500000000 2.35956800000000 2.37003700000000 2.38059700000000 2.39106600000000 2.40153600000000 2.41200500000000 2.42249800000000 2.43296800000000 2.44343700000000 2.45390600000000 2.46446600000000 2.47486900000000 2.48533800000000 2.49580800000000 2.50636800000000 2.51683700000000 2.52730600000000 2.53780000000000 2.54826900000000 2.55873800000000 2.56920800000000 2.57976800000000 2.59017000000000 2.60064000000000 2.61110900000000 2.62166900000000 2.63213800000000 2.64260800000000 2.65301000000000 2.66357000000000 2.67404000000000 2.68450900000000 2.69497800000000 2.70547200000000 2.71600800000000 2.72647700000000 2.73688000000000 2.74744000000000 2.75790900000000 2.76837800000000 2.77884800000000 2.78940800000000 2.79981000000000 2.81028000000000 2.82084000000000 2.83130900000000 2.84177800000000 2.85224800000000 2.86274100000000 2.87321000000000 2.88368000000000 2.89414900000000

I would like to know how can I convert these to standard date and time?

Thanks in advance for your help and time,

Ruben Llamas

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

F. 2012-7-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42939-how-to-convert-to-standard-date-and-time#answer_52766

在 MATLAB Online 中打开

help datestr (for the function and to define the format ...)

try:

datestr(now, 'mmmm dd, yyyy HH:MM:SS.FFF AM')

2 个评论
显示无隐藏无

Ruben Llamas 2012-7-6

I have done it, but I don't get a right date and time. For example 1.373032 needs to give 2012-06-26 15:26:17.374 and it does!

F. 2012-7-6

but

datenum( '2012-06-26 15:26:17.374', 'yyyy-mm-dd HH:MM:SS.FFF' )

gives 7.3505e+005 ????

请先登录，再进行评论。

Answer 2

Walter Roberson 2012-7-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42939-how-to-convert-to-standard-date-and-time#answer_52767

编辑：Walter Roberson 2012-7-6

datestr() might be appropriate, but we need to know how the times are encoded. For example, in the sample data, does 1.37303200000000 actually mean "1 hour 37 minutes, 30.320 seconds" ?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Star Strider 2012-7-6

How did you convert '1.373032' to '2012-06-26 15:26:17.374'? Your sensor software documentation must have some information about how it encodes dates and times. Share that information here and it may be possible to calculate MATLAB date numbers from them.

Walter Roberson 2012-7-6

If the time scheme is linear (which we do not know yet), then if you give us two timestamps and two exact conversions of those timestamps, then we can figure out the conversion. Provided, that is, that the timestamps are not relative to some time that is given in a file header line and which you have omitted showing in your question. (Times relative to a particular time are a common time format in log files.)

请先登录，再进行评论。