date and time format change

8 次查看（过去 30 天）

显示更早的评论

Charles 2019-5-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459654-date-and-time-format-change

评论： Peter Perkins 2019-5-9

采纳的回答： dpb

i have a cell n x 2 table array. The first column containd dateas in the format of

'yyyy-MM-dd''T''HH:mm:ss.SSSSSSSSS''Z'''

I wish to change this to the following format

20130501000000, = 'YYYMMDD000000', which is '%Y%m%d%H%M%S'

I will then want to change the table array to a text file

I was hoping to use something like this to change the format. Any guidance would help.

New_datetime_new = datetime(EUR_USD.Date,'inputformat','yyyy-MM-dd''T''HH:mm:ss.SSSSSSSSS''Z''');

3 个评论
显示 1更早的评论隐藏 1更早的评论

Charles 2019-5-1

See .matf ile attached. i wish to change the date format to that in the .txt file. I wish to retain the close price column and in fact make two colums of closing price and rhenc onvert this to the .txt file

dpb 2019-5-1

What is the time zone???

You don't separate the Z timezone code as a literal as do the 'T'.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

dpb 2019-5-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459654-date-and-time-format-change#answer_373180

编辑：dpb 2019-5-1

>> tst=GBP_USD.Date(1:10);         % just a sample set to play with
>> datetime(tst,'InputFormat','yyyy-MM-dd''T''HH:mm:ss.SSSSSSSSSZ', ...
                'TimeZone','Europe/London','Format','yyyyMMddHHmmss')
ans = 
  10×1 datetime array
   20190501095950
   20190501095955
   20190501100000
   20190501100005
   20190501100010
   20190501100015
   20190501100020
   20190501100025
   20190501100030
   20190501100035
>> 