Date time conversion problem

31 次查看(过去 30 天)
Ram Basnet
Ram Basnet 2021-4-14
'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

回答(2 个)

Khalid Mahmood
Khalid Mahmood 2021-4-14
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 2021-4-14
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 个评论
Ram Basnet
Ram Basnet 2021-4-14
Thankyou so Much its working now
Star Strider
Star Strider 2021-4-15
My pleasure!
If my Answer helped you solve your problem, please Accept it!
.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Dates and Time 的更多信息

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by