convert dates to specific format

4 次查看（过去 30 天）
Salma fathi
Salma fathi 2022-7-19
评论： KSSV 2022-7-19
how can I change the format of the dates in the column shown in the image to the format uuuuMMddHHmm?

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

回答（2 个）

Stephen23
Stephen23 2022-7-19
编辑：Stephen23 2022-7-19
Ran in:
My guess is that you have unfortunately stored each date as one numeric value, whose digits just happen to coincide with the date units' digits. This is rather a misuse of numerics, and is best fixed by importing that data correctly, rather than trying to "fix" it later. But you can convert to a proper DATETIME object if required:
N = 200701022359 % ugh
N = 2.0070e+11
D = datetime(string(N),'Format','uuuuMMddHHmm')
D = datetime
200701022359
Checking:
D.Year
ans = 2007
D.Day
ans = 2
D.Minute
ans = 59
Note that you should avoid deprecated functions DATENUM, DATESTR, and DATEVEC.
KSSV
KSSV 2022-7-19
Ran in:
t0 = datenum(today) % probably you have datenums
t0 = 738721
t1 = datetime(datestr(t0)) % convert them to datetime
t1 = datetime
19-Jul-2022
t1.Format % check the format
ans = 'dd-MMM-uuuu'
t1.Format = 'uuuuMMddHHmm' % change the format
t1 = datetime
202207190000
  3 个评论
显示 1更早的评论
Stephen23
Stephen23 2022-7-19
"Any advice how to fix it?"
  1. understand how your date is currently stored.
  2. use that knowledge to select a suitable tool to convert it to DATETIME.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Time Series Objects 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by