How to shift date-time variable to a common start-date/time
조회 수: 6 (최근 30일)
이전 댓글 표시
I have some data formatted as follows:
% Simple example as the "actual_dates" is a large char array.
common_date = datetime(14,1,1,0,0,0) % Define a common start date (01-Jan-0014 00:00:00)
actual_dates = '29-Jan-2014 13:57:30' % This is "char"
Then I run this:
t_diff = actual_dates - common_date % The shift value
and get this weird result:
t_diff = 17532325:57:35
The end goal is to have this:
shifted_date = actual_dates - t_diff
For this particular example, want to have shifted_date = '01-Jan-0014 00:00:00'
How can I fix this? I'm not sure how to convert the 'char' array into a datetime format.
댓글 수: 0
채택된 답변
Star Strider
2015년 6월 19일
I don’t understand what you want to do, but converting the string to a datetime object is srtaightforward. Doing calculations on them is a bit more involved, since it requires the appropriate functions.
Try this to start:
common_date = datetime(14,1,1,0,0,0);
actual_dates = '29-Jan-2014 13:57:30';
act_date = datetime(actual_dates);
t_diff = between(common_date,act_date)
produces:
t_diff =
2000y 28d 13h 57m 30s
댓글 수: 2
추가 답변 (2개)
Peter Perkins
2015년 6월 23일
편집: Peter Perkins
2015년 6월 23일
Just for the record, this
>> common_date = datetime(14,1,1,0,0,0)
common_date =
01-Jan-0014 00:00:00
>> actual_dates = '29-Jan-2014 13:57:30'
actual_dates =
29-Jan-2014 13:57:30
>> t_diff = actual_dates - common_date
t_diff =
17532325:57:30
does automatically convert the string (no need to explicitly call datetime on it, although of course it doesn't hurt). It seems a little funny that you are creating a datetime in the year 14 (not 2014), but I'll assume you meant to do that. The result simply says that there are 17.5 million hours between those two dates. This
>> t_diff.Format = 'y'
t_diff =
2000.1 yrs
is probably a more useful format, or, as StarStrider suggested, use the between function to get the difference in calendar units.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Dates and Time에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!