Convert to DateTime with Abbreviated Time Zone Code in Powershell

Asked Jun 06 '22 at 22:09

Active Jun 06 '22 at 22:37

Viewed 53 times

I'm trying to convert a timestamp string with the format:

Wed Jun 15 08:38:07 NZST 2022

(where 'NZST' is the time zone name)

Using PowerShell I've got close to a solution but can't work how to recognise the time zone code. Trying using 'zzzz' (and in uppercase) to mark the portion of the string with the time zone in it:

[DateTime]::ParseExact($stampy, "ddd MMM dd HH:mm:ss zzzz yyyy", $null)

But this gives the error: Exception calling "ParseExact" with "3" argument(s): "String was not recognized as a valid DateTime."

Is there a solution to this using ParseExact or will I need to split the string and decode the time zone code separately?

Thanks

asked Jun 06 '22 at 22:09

eddieddieddie

1

Getting the TimeZone abbreviations seem like a [fun task](https://stackoverflow.com/questions/15302083/timezone-abbreviations). – Santiago Squarzon Jun 06 '22 at 22:50
1

does this answer your [question?](https://stackoverflow.com/q/241789/8431238) – another victim of the mouse Jun 06 '22 at 22:50

Convert to DateTime with Abbreviated Time Zone Code in Powershell

0 Answers0