How to convert datetime into a number?

71 次查看(过去 30 天)
Lu Da Silva
Lu Da Silva 2022-4-3
编辑: Stephen23 2024-8-6,18:08
I have a table whose first column is a timestamp in the format 08-Jan-2016 05:40:00. How do I convert it into numbers?
Wanted output: 20160108054000.
I know the function yyyymmdd(X) is useful but I also need the time to be added.
Thanks!

回答(2 个)

KSSV
KSSV 2022-4-3
dt = datestr(now,'yyyymmddHHMMSS')
dt = '20220403132156'
  5 个评论
Siddharth Bhutiya
Avoid using older legacy functions like datestr and datenum. Use the more modern types like datetime to work with timestamped data.
@Lu Da Silva Could you share a code example to demonstrate what you are seeing. This way people can run that on their MATLAB and suggest possible solutions instead of trying to guess what the problem could be.
Boyd Tolton
Boyd Tolton 2024-8-6,17:41
Although datetime does provide more precision than datenum (and requires more memory), this precision is not needed by most applications. Also, you will note that the dir command outputs the datenum for files.

请先登录,再进行评论。


Stephen23
Stephen23 2024-8-6,17:48
编辑:Stephen23 2024-8-6,18:08
txt = '08-Jan-2016 05:40:00'
txt = '08-Jan-2016 05:40:00'
dtn = datetime(txt,'InputFormat','d-MMM-y H:m:s', 'Format','yyyyMMddHHmmss')
dtn = datetime
20160108054000

类别

Help CenterFile 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