Convert string to PowerShell DateTime

Question

I have the following string: "02-06-2018 16:25:28". I need to convert it to a DateTime object. I tried doing this:

[DateTime]::ParseExact('02-06-2018 16:25:28', 'dd-MM-yyyy hh:mm:ss', $null)

But it did not work:

String was not recognized as a valid DateTime.

Is there another function other than [DateTime]::ParseExact that supports parsing the string in this fomat dd-MM-yyyy hh:mm:ss?

I'm using PowerShell v5.1.

Ansgar Wiechers · Accepted Answer · 2018-02-06 22:32:48Z

9

You need HH for a 24-hour clock. hh is for a 12-hour clock, which doesn't recognize a 16th hour. I would also recommend using InvariantCulture instead of $null, as the latter sometimes won't work.

$culture = [Globalization.CultureInfo]::InvariantCulture
[DateTime]::ParseExact('02-06-2018 16:25:28', 'MM-dd-yyyy HH:mm:ss', $culture)

edited Feb 6, 2018 at 22:32

answered Feb 6, 2018 at 9:53

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RonaDona Over a year ago

Ah, that was it. Thanks a lot. (btw, edit your answer, you wrote 'hh', not 'HH' in the code.

Ansgar Wiechers Over a year ago

@RonaDona Yeah, thanks for the heads up. BTW, your example timestamp looks like it was from today. If that's the case you also need to change dd-MM-yyyy to MM-dd-yyyy.

Dizzy · Accepted Answer · 2018-02-07 16:11:25Z

2

You can pass date/time strings to Get-Date as well, it will convert them for you: get-date "02-06-2018 16:25:28" for example. This will return a System.DateTime object and can be manipulated in the usual ways by powershell.

answered Feb 7, 2018 at 16:11

Dizzy

1114 bronze badges

Collectives™ on Stack Overflow

Convert string to PowerShell DateTime

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related