How to convert time format

14 次查看（过去 30 天）
L
L 2019-4-24
评论： Walter Roberson 2019-5-3
I am trying to convert the following time format (example): 1975-092T00:04:17.237 to just seconds. I have read the page https://www.mathworks.com/help/matlab/ref/datenum.html but this specific time format is giving me trouble (it is earth received time). Has anyone worked with this time format or have a simple way of converting? My data is a matrix wherein one column is time in this format. Thank you!

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

采纳的回答

Walter Roberson
Walter Roberson 2019-4-24
datetime(TheString, 'InputFormat', 'uuuu-DDD''T''HH:mm:ss.SSS')
Note that this date does not include any timezone information. The 'T' does not imply anything about time zone.
It would be common for times in this format to be immediately followed by some timezone information such as ending in Z
  6 个评论
显示 4更早的评论
Peter Perkins
Peter Perkins 2019-5-3
" I was trying to convert this to just seconds"
L, you may also mean, "convert to seconds from some reference time." Create the reference as a datetime and subtract. The result is a duration:
> dt = datetime('1975-092T00:04:17.237', 'Format', "uuuu-DDD'T'HH:mm:ss.SSS")
dt =
datetime
1975-092T00:04:17.237
>> et = dt - datetime(1970,1,1)
et =
duration
46008:04:17
>> et.Format = 's'
et =
duration
165629057.237 sec
Walter's right that such timestamps often have a time zone suffix. Also "earth received time" makes me think that maybe you care about leap seconds, in which case you might want to set the result's timezone to 'UTCLeapSeconds':
>> et2 = dt - datetime(1970,1,1,'TimeZone','UTCLeapSeconds')
pt2 =
duration
46008:04:21
>> et2.Format = 's'
et2 =
duration
165629061.237 sec
Walter Roberson
Walter Roberson 2019-5-3
Ah, I completely missed the significance of "earth received time".

请先登录，再进行评论。

更多回答（0 个）

类别

在 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