Using System.DateTime in a Timetable

18 次查看（过去 30 天）

显示更早的评论

Sebastian Ehrismann 2021-6-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/859360-using-system-datetime-in-a-timetable

评论： Steven Lord 2021-6-22

采纳的回答： Scott MacKenzie

在 MATLAB Online 中打开

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Scott MacKenzie 2021-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/859360-using-system-datetime-in-a-timetable#answer_727555

在 MATLAB Online 中打开

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 个评论
显示 5更早的评论隐藏 5更早的评论

Scott MacKenzie 2021-6-22

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 2021-6-22

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.

请先登录，再进行评论。