How to convert timestamp string to datetime object in matlab
212 ビュー (過去 30 日間)
古いコメントを表示
Hi every body
I have an excel file, one column is date and time in this firmat:(the file is datas of power in each about 3 seconds)
1303133628.00000
1303133632.00000
1303133635.00000
1303133639.00000
1303133642.00000
how can I convert it to date time in format like:
2011-04-18 21:22:13
thanks
0 件のコメント
採用された回答
Rik
2021 年 7 月 1 日
UTC_epoch_seconds=1303133628;
UTC_offset=UTC_epoch_seconds/(24*60*60);
atomTime=UTC_offset+datenum(1970,1,1);
datetime(atomTime,'ConvertFrom','datenum')
その他の回答 (1 件)
Smitesh Patil
2021 年 7 月 1 日
If the data is stored in array 'x' then you can pass it to datatime in the following manner
d = datetime(x,'ConvertFrom','posixtime', 'Format', 'yyyy-MM-dd HH:mm:ss')
参考
カテゴリ
Help Center および File Exchange で Dates and Time についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!