Date and time formate translation

5 次查看(过去 30 天)
I need to translate those dates and time (strings)
'25-Mar-2014 13:00:00'
'07-Nov-2018 18:30:45'
to the forllowing format (in string as well):
'2014-03-25T13:00:00.000Z'
'2018-11-07T18:30:45.000Z'
Any idea how to handle such kind of formats? I find it pretty complex...

采纳的回答

dpb
dpb 2018-12-1
编辑:dpb 2018-12-1
dt=datetime('25-Mar-2014 13:00:00');
fmt= 'uuuu-MMM-dd''T''HH:mm:ss.SSS''Z';
dt.Format=fmt;
>> dt =
datetime
2014-Mar-25T13:00:00.000Z
>>
  3 个评论
dpb
dpb 2018-12-1
Yes. datestr is a remnant of the deprecated datenum that didn't have a formatting option; it is just a particularly-scaled double.
char(dt) is the idiom if need the character array; for most purposes however, either cellstr or string is probably more useful/less coding downstream--but depends upon just why you actually need the string representation at all...
Martin
Martin 2018-12-2
编辑:Martin 2018-12-2
I need to get a response from a statistical data API on the internet. This API only takes this kind of format. Do you have any suggestion how to get posix time from the format? string: timestr='2014-03-25T13:00:00.000Z'?
EDIT: Okay figured out. First I use t= datetime(timestr,'Format','yyyy-MM-dd''T''HH:mm:ss.SSS''Z')
then just posixtime(t)

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Type Conversion 的更多信息

产品

Community Treasure Hunt

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

Start Hunting!

Translated by