Date time conversion problem
31 views (last 30 days)
Show older comments
'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.
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
0 Comments
Answers (2)
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');
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
.
4 Comments
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!