Change the format of all Datetime variables in a Table

28 visualizaciones (últimos 30 días)
Haris K.
Haris K. el 12 de Oct. de 2020
Editada: Adam Danz el 8 de Mayo de 2023
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.

Respuesta aceptada

Walter Roberson
Walter Roberson el 13 de Oct. de 2020
Editada: Adam Danz el 8 de Mayo de 2023
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 comentarios
Gabor
Gabor el 25 de Nov. de 2022
Undefined function 'convertvars' for input arguments of type 'datetime'.
Stephen23
Stephen23 el 25 de Nov. de 2022
Editada: Stephen23 el 25 de Nov. de 2022
@Gabor: CONVERTVARS was introduced in R2018b. Are you using an earlier version?

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Productos


Versión

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by