Parse variable in a table
2 views (last 30 days)
Show older comments
Hi,
I have a variable in a table, timestamp, in the following format:
2023-02-24 13:00:00
How can I parse this variable into two new variables, date (2023-02-24) and time (13:00:00)?
Any help would be appreciated!
IP
0 Comments
Accepted Answer
Star Strider
on 8 Aug 2023
Edited: Star Strider
on 8 Aug 2023
Several options, depending on what you want —
timestamp = '2023-02-24 13:00:00'
DT = datetime(timestamp)
Date = DT;
Time = DT;
Date.Format = 'yyyy-MM-dd'
Time.Format = 'HH:mm:ss'
Date = extractBefore(timestamp, ' ')
Time = extractAfter(timestamp, ' ')
DateTime = strsplit(timestamp, ' ')
.
2 Comments
More Answers (0)
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!