Time Stamp is a Large Number

Question

Cameron Power 2018-6-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406564-time-stamp-is-a-large-number

回答： Peter Perkins 2018-7-5

I am trying to break apart this file I have but the time column has a large number as the time (this is because the time is in 5 minute intervals). As an example 201601010000 (shown in Matlab as 2.0160101000e+11) represents January 1, 2016, 12:00AM or 00:00Hr (24 Hr time). Any help is welcome, thank you.

2 个评论
显示无隐藏无

Stephen23 2018-6-20

@Cameron Power: Please upload a sample file by clicking the paperclip button. Several file importing functions correctly import dates without requiring them to be converted to/from a large number, and they are the recommended way to handle dates.

Cameron Power 2018-6-20

aaab-dbase-2016-04-21.csv.zip

Here is a csv sample

请先登录，再进行评论。

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

Answer 1

Stephen23 2018-6-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406564-time-stamp-is-a-large-number#answer_325497

编辑：Stephen23 2018-6-20

在 MATLAB Online 中打开

Use either readtable or textscan and set the format to specify the date, something like this:

N = number of columns
fmt = repmat('%f',1,N-1);
fmt = ['%{yyyyMMddHHmmss}D',fmt];

Both readtable and textscan contain a useful example under the heading "Read Foreign-Language Dates", you should try those examples and adapt them to your situation.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Peter Perkins 2018-7-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406564-time-stamp-is-a-large-number#answer_327642

在 MATLAB Online 中打开

If you have text, Stephen's advice is good. If you have a number, you can split it into two pieces and use datetime to do at least part of the work:

>> x = 201601010000
x =
              201601010000
>> xdate = floor(x/10000)
xdate =
    20160101
>> xtime = x - 10000*xdate
xtime =
     0
>> datetime(xdate,'ConvertFrom','yyyymmdd')
ans = 
  datetime
   01-Jan-2016 00:00:00