How to convert timestamp string to datetime object in matlab

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

Answer 1

[Rik]

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

[Maryam BODAGHI]

thanks so much

Answer 2

[Smitesh Patil]

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')

[Maryam BODAGHI]

thanks so much