datetime and changing the month format

SKG
2019 2 2
1 个回答
回答已采纳
更新时间：2019 2 2
5 次查看（30 天）

0 个投票

Hey everyone,
I am trying to change the date input from csv file to another format that I want to use it for sorting.
The input of csv file:
Input=
'2019-01-25 17:00:17'
'2019-01-25 17:26:59'
'2019-01-25 17:39:31'
'2019-01-31 17:15:47'
-Output=datetime(Input,'InputFormat','yyyy-MM-dd HH:mm:ss');
Output:
'25-Jan-2019 17:00:17'
'25-Jan-2019 17:26:59'
'25-Jan-2019 17:39:31'
'31-Jan-2019 17:15:47'
However, I want the output 01-25-2019 HH:mm:ss
What is the best way to do that?

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

 采纳的回答

Walter Roberson
Walter Roberson 2019-2-2
编辑：Walter Roberson 2019-2-2

0 个投票

Output = atetime(Input, 'InputFormat', 'yyyy-MM-dd HH:mm:ss', 'Format', 'MM-dd-yyyy HH:mm:ss')
Caution: using month day year rather than day month year does lead to international confusion.
Last time I did my taxes, I had a heck of a time figuring out the strange timings on some of my receipts until I realized that every once in a while they accidentally switched to m/d/y instead of d/m/y .

更多回答（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