필터 지우기
필터 지우기

How do to get a specific time from datetime format in Matlab?

조회 수: 9 (최근 30일)
Kofial
Kofial 2020년 11월 11일
댓글: Kofial 2020년 11월 12일
I have these data:
x=(17-Apr-2020 06:59:00,17-Apr-2020 07:00:00,17-Apr-2020 07:01:00,17-Apr-2020,07:02:0017-Apr-2020,07:03:00)
y=(06:58:30,17-Apr-2020 06:59:30,17-Apr-2020 07:00:30,17-Apr-2020 07:01:30,17-Apr-2020 07:02:30,17-Apr-2020 07:03:30)
Both times (x,y) are in the datetime format).
To get the time for x from 07:00:00 till the end I do this:
interpolation_time = (x(420):minutes(1):x(end));
For y I need it from 07:00:30 till the end. How can I do it? It has a different timestamp.
Thank you!

채택된 답변

Walter Roberson
Walter Roberson 2020년 11월 11일
편집: Walter Roberson 2020년 11월 11일
[xh, xm, xs] = hms(x);
xidx = find(xh >= 7 & xm >= 0, 1);
[yh, ym, ys] = hms(y);
yidx = find(yh >= 7 & ym >= 0 & ys >= 30, 1);
selected_x = x(xidx:end);
selected_y = y(yidx:end);
Note here that this code is perfectly happy if the dates do not match at all, and if the entries are out of order. Your problem definition involved finding the first entry that meets a particular time-based criteria that ignores dates.
Perhaps you should use isbetween() ?
See also dateshift() -- for example
xbase = dateshift(x(1), 'start', 'day');
dx = x - xbase;
dy = y - xbase;
maskx = dx >= hours(7);
masky = dy >= hours(7) + seconds(30);
  댓글 수: 1
Steven Lord
Steven Lord 2020년 11월 11일
You can compute dx and dy without computing xbase using the timeofday function for datetime arrays.
dt = datetime('now') + hours(48*randn(10, 1)) + minutes(60*randn(10, 1));
td = timeofday(dt);
results = table(dt, td, 'VariableNames', ["Date and time", "Time since midnight"])
results = 10x2 table
Date and time time since midnight ____________________ ___________________ 09-Nov-2020 07:06:30 07:06:30 10-Nov-2020 16:46:13 16:46:13 09-Nov-2020 20:24:50 20:24:50 12-Nov-2020 20:58:31 20:58:31 10-Nov-2020 09:09:45 09:09:45 09-Nov-2020 02:58:16 02:58:16 13-Nov-2020 12:14:36 12:14:36 11-Nov-2020 13:15:02 13:15:02 12-Nov-2020 01:21:48 01:21:48 09-Nov-2020 12:10:02 12:10:02

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

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