Using System.DateTime in a Timetable
16 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Sebastian Ehrismann
el 18 de Jun. de 2021
Comentada: Steven Lord
el 22 de Jun. de 2021
Hello everyone,
i am importing Data from a Database and want to save the timestamps and the values in a timetable. However the Time gets imported as System.DateTime, which I cannot use in a timetable, at least I get an error, when I try.
The System.DateTime 'netTime' looks like this:
K>> netTime(1)
ans =
DateTime with properties:
Date: [1×1 System.DateTime]
Day: 29
DayOfWeek: Thursday
DayOfYear: 119
Hour: 6
Kind: Unspecified
Millisecond: 300
Minute: 0
Month: 4
Now: [1×1 System.DateTime]
UtcNow: [1×1 System.DateTime]
Second: 0
Ticks: 637552728003000000
TimeOfDay: [1×1 System.TimeSpan]
Today: [1×1 System.DateTime]
Year: 2021
MinValue: [1×1 System.DateTime]
MaxValue: [1×1 System.DateTime]
What i Want is to only the Time hh:mm:ss:ms from this "cell" to use in a TT.
Can anyone tell me what I need to do?
Thanks in advance
0 comentarios
Respuesta aceptada
Scott MacKenzie
el 18 de Jun. de 2021
This converts the System.DateTime variable returned by netTime to a datetime variable, which can then be used with timetable:
t = netTime(1); % t is System.DateTime variable
% convert to datetime variable
t2 = datetime(t.Year, t.Month, t.Day, t.Hour, t.Minute, t.Second, t.Millisecond)
7 comentarios
Scott MacKenzie
el 22 de Jun. de 2021
You're welcome.
Obviously, issues with execution time relate to retrieving data from the database. I really don't have any insights to offer on this. Sorry.
Steven Lord
el 22 de Jun. de 2021
Profile the code (possibly on a small sample of your data) to identify the bottlenecks. Depending on what the code in the bottlenecks is doing it may be possible to speed them up, but it could be difficult if not impossible to offer specific guidance without seeing the actual code you're executing.
Más respuestas (0)
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!