清空筛选条件
清空筛选条件

Parse variable in a table

2 次查看（过去 30 天）
Inna Pelloso
Inna Pelloso 2023-8-8
评论： Star Strider 2023-8-8
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

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2023-8-8
编辑：Star Strider 2023-8-8
Ran in:
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.
.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by