Convert a time string to double

15 views (last 30 days)
Tasnim Sayadi
Tasnim Sayadi on 4 Aug 2022
Commented: Star Strider on 5 Aug 2022
Hi everyone,
I have a timestamp vector in seconds (in range 1.6573e+9 ) and converted it to datetime (I get for expl. 08-Jul-2022 09:42:56)
t = datetime(1970,1,1) + seconds(timeStamps) + hours(2);
I'm not sure why I need to add 2 hours, but it works correctly. Now I want to search to see if the date I entered is included in timeStamps. Since my input date is a string and timeStamps is a double, I need to convert my date to double
ts = datenum( t - datetime(1970,1,1) - hours(2) ) ;
I used the same converted vector t to test if I get the same values for timeStamps, but I get a wrong answer (in range 1.9181e+04)
So I wonder if someone can help me to solve this problem? Thank you
  2 Comments
Steven Lord
Steven Lord on 4 Aug 2022
I have a timestamp vector in seconds (in range 1.6573e+9 ) and converted it to datetime
Instead of manually creating the datetime representing January 1st, 1970 I'd suggest using the 'ConvertFrom' option for datetime with the 'posixtime' option.
...
Since my input date is a string and timeStamps is a double, I need to convert my date to double
No. Convert your string representing a date and time to a datetime array instead. Then use isbetween or relational operators (greater than, less than, etc.) on the datetime arrays.

Sign in to comment.

Answers (1)

Star Strider
Star Strider on 4 Aug 2022
I am not certain what you are doing, however the isbetween function (that does not require conversion out of datetime) may be what you want.
  2 Comments
Star Strider
Star Strider on 5 Aug 2022
The isbetween funciton returns a logical vector. Assuming your data are column-oriented, you would get all the rows with something like this —
Lv = isbetween(t, tupper, tupper); % Logical Vector
AllData = T{Lv,:}; % Return Matrix Of Relevant Data
where ‘t’ are the datetime data and ‘T’ is the table that contains it and the other data. (Note the use of curly brackets {} to return a matrix rather than a table.)
See the documentation I linked to earlier for more information.
.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!