Convert datetime to numeric - preserve date format

41 次查看（过去 30 天）

Elin Jacobs 2023-2-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1919980-convert-datetime-to-numeric-preserve-date-format

评论： Campion Loong 2023-3-29

I have a timetable with dates (datetime data type) in the format 'yyyy-MM-dd HH:mm'. I want to convert these to a numeric data type (double) but keeping the exact numbers of each date such that the datetime '2023-02-27 14:00' is converted to the double '202302271400'. The function yyyymmdd() allows me to do this for the date, but not the hour and minute, and none of the other built in functions to convert to datenumber seem to have this option. Thanks for any insights to this problem.

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

请先登录，再进行评论。

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

采纳的回答

Les Beckham 2023-2-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1919980-convert-datetime-to-numeric-preserve-date-format#answer_1181120

编辑：Les Beckham 2023-2-28

在 MATLAB Online 中打开

Edited to work with datetime array vs a single datetime.

d = datetime(['2023-02-27 14:00'; '2023-02-27 15:00']) % test data - replace with your timetable 
d = 2×1 datetime array
   27-Feb-2023 14:00:00
   27-Feb-2023 15:00:00
s = string(d, 'yyyyMMddHHmm')
s = 2×1 string array
    "202302271400"
    "202302271500"
format long
% f = cellfun(@(s)sscanf(s, '%f'), s) % original method of converting to double
f = double(s) % An easier/cleaner method.  Thanks to Walter for reminding me about this.
f = 2×1
1.0e+11 *

   2.023022714000000
   2.023022715000000
compose('%.0f', f)
ans = 2×1 cell array
    {'202302271400'}
    {'202302271500'}