Powershell parse DateTime

Question

I want to parse this String I get from OpenSSL to DateTime:

Dec 23 03:54:47 2021

I tried the following things without success:

([datetime]::ParseExact($datestring, "%b %H:%M:%S %Y", $null))

([datetime]::ParseExact($datestring, "bbb HH:MM:SS YYYY", $null))

Mathias R. Jessen · Accepted Answer · 2021-09-22 12:57:53Z

2

The format string you want is MMM dd HH:mm:ss yyyy:

PS ~> [datetime]::ParseExact('Dec 23 03:54:47 2021', 'MMM dd HH:mm:ss yyyy', $null)

Thursday, December 23, 2021 3:54:47 AM

As Olaf mentions, the month name specifiers will only work on English month names when the current locale is English.

If you want to always parse English month names regardless of OS localization settings, explicitly pass an en-US Culture object for the 3rd method parameter:

$targetCulture = [cultureinfo]::new('en-US')
[datetime]::ParseExact('Dec 23 03:54:47 2021', 'MMM dd HH:mm:ss yyyy', $targetCulture)

edited Sep 22, 2021 at 12:57

answered Sep 22, 2021 at 7:58

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

3 Comments

Olaf Over a year ago

This only works for english systems. When you have another you may replace $null with [system.globalization.cultureinfo]("en-US")

GhostJumper Over a year ago

@Olaf thx for the comment. Adding that worked

Olaf Over a year ago

;-) ... You're welcome.

Collectives™ on Stack Overflow

Powershell parse DateTime

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related