Date time conversion problem

20 views (last 30 days)
Ram Basnet
Ram Basnet on 14 Apr 2021
Commented: Star Strider on 15 Apr 2021
'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

Answers (2)

Khalid Mahmood
Khalid Mahmood on 14 Apr 2021
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');
  1 Comment
Ram Basnet
Ram Basnet on 14 Apr 2021
Thankyou. Its working now.

Sign in to comment.


Star Strider
Star Strider on 14 Apr 2021
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
.
  2 Comments
Star Strider
Star Strider on 15 Apr 2021
My pleasure!
If my Answer helped you solve your problem, please Accept it!
.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by