Matlab is mixing MONTH and DAY up

5 次查看（过去 30 天）
Louise Wilson
Louise Wilson 2021-3-18
评论： Star Strider 2021-3-22
Hello, I have a datetime array where the format is dd/MM/yyyy, but when I used ymd(), Matlab tells me that day is month and month is day. Using format() just rearranges the date but retains the confusion between day and month.
How do I rectify this, how can I dictate to Matlab which is the month and which is the day?
[y,m,d]=ymd(gps.LOCALDATE(1))
y =
2021
m =
9 %this is actually the day
d = %this is actually the month
3
  2 个评论
Louise Wilson
Louise Wilson 2021-3-22
@Star Strider Sorry, I can't share the data because it is sensitive but I can give a subset.
Louise Wilson
Louise Wilson 2021-3-22
I think I need to specify the format of the LOCALDATE data as I read it in but not sure how to do that.

请先登录，再进行评论。

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

采纳的回答

Star Strider
Star Strider 2021-3-22
编辑：Star Strider 2021-3-22
Try this:
D = load('gps.mat');
gps = D.gps;
LOCALDATETIME = datetime(string(gps.LOCALDATE),'InputFormat','dd/MM/yyyy', 'Format','dd/MM/yyyy HH:mm:ss') + gps.LOCALTIME;
with:
First_5_Rows = LOCALDATETIME(1:5)
producing:
First_5_Rows =
5×1 datetime array
09/03/2021 08:42:31
09/03/2021 08:42:32
09/03/2021 08:42:34
09/03/2021 08:42:35
09/03/2021 08:42:36
Since ‘gps.LOCALDATE’ is already a datetime array, converting it first to a string variable allowed datetime to parse it correctly.
EDIT — Added explanation.

更多回答（0 个）

类别

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

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by