How to go from datetime (yyyy:mm: dd hh:mm:ss) to seconds?

I have a timestamp variable with the following output (size: 1207x1):

'2023-06-27 08:31:05'

'2023-06-27 08:31:06'

'2023-06-27 08:31:07'

'2023-06-27 08:31:08'

etc.

How do I turn this into a variable where it is only seconds?

I tried the function datevec, but after every minute the seconds get to zero again, but I want the amount of seconds to continue after a minute.

Thanks in advance!

[Torsten]

How do I turn this into a variable where it is only seconds?

So for the first timestamp, e.g., you mean 8*3600 + 31*60 + 5 ?

[Ilse Frans]

Yes, but the function time2num worked so all is good :)

Thanks!

[Stephen23]

MATLAB does not have a TIME2NUM function. The Predictive Maintenance toolbox has such a function.

The MATLAB approach is to use a DATETIME variable and then call TIMEOFDAY and SECONDS (all of which are actual MATLAB functions):

C = {'2023-06-27 08:31:05';'2023-06-27 08:31:06';'2023-06-27 08:31:07';'2023-06-27 08:31:08'};
T = datetime(C)

T = 4×1 datetime array
   27-Jun-2023 08:31:05
   27-Jun-2023 08:31:06
   27-Jun-2023 08:31:07
   27-Jun-2023 08:31:08

V = seconds(timeofday(T))

V = 4×1

30665 30666 30667 30668

[Peter Perkins]

Or maybe "seconds since some origin"

C = ["2023-06-27 08:31:05";"2023-06-27 08:31:06";"2023-06-27 08:31:07";"2023-06-27 08:31:08"];
T = datetime(C)

T = 4×1 datetime array
   27-Jun-2023 08:31:05
   27-Jun-2023 08:31:06
   27-Jun-2023 08:31:07
   27-Jun-2023 08:31:08

s = T - "1-Jan-2023"; s.Format = 's'

s = 4×1 duration array
   1.5323e+07 sec
   1.5323e+07 sec
   1.5323e+07 sec
   1.5323e+07 sec

seconds(s) % as numeric

ans = 4×1

15323465 15323466 15323467 15323468

Answer 1

[Ilse Frans]

Nevermind, tried the function time2num and worked :)