Clear Filters
Clear Filters

Parse variable in a table

3 views (last 30 days)
Inna Pelloso
Inna Pelloso on 8 Aug 2023
Commented: Star Strider on 8 Aug 2023
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

Accepted Answer

Star Strider
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'
timestamp = '2023-02-24 13:00:00'
DT = datetime(timestamp)
DT = datetime
24-Feb-2023 13:00:00
Date = DT;
Time = DT;
Date.Format = 'yyyy-MM-dd'
Date = datetime
2023-02-24
Time.Format = 'HH:mm:ss'
Time = datetime
13:00:00
Date = extractBefore(timestamp, ' ')
Date = '2023-02-24'
Time = extractAfter(timestamp, ' ')
Time = '13:00:00'
DateTime = strsplit(timestamp, ' ')
DateTime = 1×2 cell array
{'2023-02-24'} {'13:00:00'}
EDIT — Added strsplit call.
.

More Answers (0)

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!