How to parse string as local date and convert it to UTC in Powershell?

Question

I have a log that I want to parse and, among other things, convert the date/time from the current local format to UTC and convert it back to text.

I have the logic to do everything except the conversion part.

$_.Line -replace '(d{4}-d{2}-d{2}sd{2}:d{2}:d{2})',(conversion_here)

Answer 1

You can use the [DateTime] object for this:

([DateTime]'2015-07-03 10:58:00').Date.ToUniversalTime()

For your replacement scenario, you could use:

$pattern = '(d{4}-d{2}-d{2}sd{2}:d{2}:d{2})'
if ($line -match $pattern) {
    $utcStr = ([DateTime]$matches[1]).ToUniversalTime().ToString('yyyy-MM-dd HH:mm:ss')
    $line -replace $pattern, $utcStr
}