Date time conversion problem

'2015-01-01T19:00:00+0100'

'2015-01-01T20:00:00+0100'

I a trying to convert the format to datetime array using a.dates_extracted= datetime(a.dates_extracted,"InputFormat","uuuu-MM-dd'T'HH:mm:ss", "TimeZone", '+0100'); command but I am getting error.

Error using datetime (line 636)

Unable to convert the text to datetime using the format 'uuuu-MM-dd'T'HH:mm:ss'. If the date/time text contain day, month, or time zone names in a language foreign to the 'en_US' locale, those might not be recognized. You can specify a different locale using the 'Locale' parameter.

please help me

Answer 1

[Khalid Mahmood]

Don't specify as T19:00:00. Oly T19:00 is enough. Furthermore use T:HH:mmXXX instead of TH:mm:ss

following code works fine.

a.dates_extracted ={'2015-01-01T19:00+01:00';'2015-01-01T20:00+01:00'} 
a.dates_extracted = datetime(a.dates_extracted,'InputFormat','uuuu-MM-dd''T''HH:mmXXX','TimeZone','+01:00');

[Ram Basnet]

Thankyou. Its working now.

Answer 2

[Star Strider]

The posted code has errors.

Try this:

A = ['2015-01-01T19:00:00+0100'
     '2015-01-01T20:00:00+0100'];

dates_extracted= datetime(A,'InputFormat','uuuu-MM-dd''T''HH:mm:ss+0100','TimeZone','+01:00')

producing:

dates_extracted = 

  2×1 datetime array

   01-Jan-2015 19:00:00
   01-Jan-2015 20:00:00

.

[Ram Basnet]

Thankyou so Much its working now

[Star Strider]

My pleasure!

If my Answer helped you solve your problem, please Accept it!

.