how to convert to standard date and time

2 次查看（过去 30 天）
Ruben Llamas
Ruben Llamas 2012-7-6
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

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

回答（2 个）

F.
F. 2012-7-6
help datestr (for the function and to define the format ...)
try:
datestr(now, 'mmmm dd, yyyy HH:MM:SS.FFF AM')
  2 个评论
Ruben Llamas
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.
F. 2012-7-6
but
datenum( '2012-06-26 15:26:17.374', 'yyyy-mm-dd HH:MM:SS.FFF' )
gives 7.3505e+005 ????

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2012-7-6
编辑：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更早的评论
Star Strider
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
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.)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by