Date and time formate translation

4 visualizzazioni (ultimi 30 giorni)
Martin
Martin il 1 Dic 2018
Modificato: Martin il 2 Dic 2018
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...
  2 Commenti
madhan ravi
madhan ravi il 1 Dic 2018
what does T and Z represent just curious?
Martin
Martin il 1 Dic 2018
Actually I Dont Know!

Accedi per commentare.

Risposta accettata

dpb
dpb il 1 Dic 2018
Modificato: dpb il 1 Dic 2018
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 Commenti
dpb
dpb il 1 Dic 2018
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 il 2 Dic 2018
Modificato: Martin il 2 Dic 2018
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)

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Data Type Conversion in Help Center e File Exchange

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by