convert datestring to datenum problem.

Hi

Does anybody know how to convert this date to number:

My date is 2016-11-22T13:12:47.320Z Now I am trying to convert it to number.

op_datetime = '2016-11-22T13:12:47.320Z';

format = 'yyyy-mm-ddTHH:MM:SS.FFFZ';

datenum(op_datetime, format)

I tryed like this above, but it is giving error.

Thanks!

[Jan]

Please post the error message.

[davit petraasya]

DATENUM failed.

Error in ==> andijan at 19

date_num=datenum(op_datetime, format)

Caused by: Error using ==> dtstr2dtnummx

    Failed on converting date string to date number.

Answer 1

[Jan]

The trailing 'Z' is not recognized.

op_datetime = '2016-11-22T13:12:47.320Z';
format = 'yyyy-mm-ddTHH:MM:SS.FFF';   % No trailing 'Z'
datenum(op_datetime, format)

[davit petraasya]

Thanks Simon, it works!

Answer 2

[Peter Perkins]

In R2014b or later, you should consider using datetimes, not datenums:

>> s = '2016-11-22T13:12:47.320Z'
s =
    '2016-11-22T13:12:47.320Z'
>> d = datetime(s,'Format','yyyy-MM-dd''T''HH:mm:ss.SSS''Z''')
d = 
   2016-11-22T13:12:47.320Z

You might want to create the datetimes with the time zone set to UTC, and people working with timestamps that look like that often care about leap seconds:

>> d = datetime(s,'Format','yyyy-MM-dd''T''HH:mm:ss.SSSX','TimeZone','UTC')
d = 
   2016-11-22T13:12:47.320Z
>> d = datetime(s,'TimeZone','UTCLeapSeconds')
d = 
   2016-11-22T13:12:47.320Z