Date time conversion problem

22 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');

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
Ram Basnet
Ram Basnet on 14 Apr 2021
Thankyou so Much its working now
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.

Categories

Find more on Dates and Time in Help Center and File Exchange

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!