Change the format of all Datetime variables in a Table
조회 수: 88 (최근 30일)
이전 댓글 표시
Is there any way to change the format of all the datetime variables in a table?
Var1 = datetime({'2015-12-18 08:03:05';'2015-12-18 10:03:17'});
Var2 = [20; 90]
Var3 = datetime({'2016-12-18 00:03:00';'2017-12-28 12:11:00'});
T = table(Var1, Var2, Var3);
S = vartype('datetime')
T{:,S}.Format = 'dd/MM/yyyy' %This does not work
What I would like to achieve is the result obtained from the following:
T.Var1.Format = 'dd/MM/yyyy'
T.Var3.Format = 'dd/MM/yyyy'
The thing though is that I am looping over different tables T, and at some iterations either (or both) Var1 and Var3 can be empty. Therefore, doing the latter method (i.e. setting the format of each variable individually) returns an error: Unable to perform assignment because dot indexing is not supported for variables of this type. Also, I have a lot more variables, so I would like to avoid if-isempty()-statements. Hence, I was wondering if there is a way to change the format of a few selected variables (-datetimes-) at once.
댓글 수: 0
채택된 답변
Walter Roberson
2020년 10월 13일
편집: Adam Danz
2023년 5월 8일
T = convertvars(T, @isdatetime, @(t) datetime(t, 'Format', 'dd/MM/yyyy'))
I tested to confirm that passing a datetime object as the parameter to datetime() can be used to construct new objects with different properties.
댓글 수: 4
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Type Identification에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!