Parse variable in a table

2023 8 8
1 个回答
回答已采纳
更新时间：2023 8 8
1 次查看（30 天）

0 个投票

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:

0 个投票

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 个）

类别

在 帮助中心 和 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