Parse variable in a table

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

Answer 1

[Star Strider]

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.

.

[Inna Pelloso]

Thank you!

[Star Strider]

As always, my pleasure!