清空筛选条件
清空筛选条件

How to convert timestamp string to datetime object in matlab

191 次查看（过去 30 天）
Maryam BODAGHI
Maryam BODAGHI 2021-7-1
评论： Maryam BODAGHI 2021-7-1
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

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

采纳的回答

Rik
Rik 2021-7-1
Ran in:
UTC_epoch_seconds=1303133628;
UTC_offset=UTC_epoch_seconds/(24*60*60);
atomTime=UTC_offset+datenum(1970,1,1);
datetime(atomTime,'ConvertFrom','datenum')
ans = datetime
18-Apr-2011 13:33:48

更多回答（1 个）

Smitesh Patil
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!

Translated by