How to convert time from string with format ‘Sunday, September 13, 2020 8:49:32 AM CDT’ to DateTime object.
Get-Date -Date 'September 13, 2020 8:49:32 AM'
But the time zone in string is in CDT domain, if get-date command is used time will be my system timezone.
Would it be possible to get DateTime for ‘Sunday, September 13, 2020 8:49:32 AM CDT‘ (This is in CDT timezone) and get it converted to system timezone.
You cannot capture time zone in this format (CDT, PDT, BST, etc.). You have to use an offset instead or do a time conversion with it stripped from the datetime string.
$SourceTimeZone = [TimeZoneInfo]::FindSystemTimeZoneById('Central Standard Time')
$DestinationTimeZone = [TimeZoneInfo]::Local
$DateString = 'Sunday, September 13, 2020 8:49:32 AM CDT'
[TimeZoneInfo]::ConvertTime(($DateString -replace '\s+CDT'),$SourceTimeZone,$DestinationTimeZone)
Here is one method:
[System.TimeZoneInfo]::ConvertTimeBySystemTimeZoneId((Get-Date), 'Central Standard Time')
Timezones can be enumerated like so:
foreach ($timezone in ([timezoneinfo]::GetSystemTimeZones() | select displayname, id)) {
'Time in zone {0} is {1} with a local time of {2}' -f $timezone.Id,
[System.TimeZoneInfo]::ConvertTimeBySystemTimeZoneId((Get-Date), $timezone.id),
(Get-Date)
}
Output:
Time in zone Dateline Standard Time is 9/16/2020 2:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone UTC-11 is 9/16/2020 3:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Aleutian Standard Time is 9/16/2020 5:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Hawaiian Standard Time is 9/16/2020 4:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Marquesas Standard Time is 9/16/2020 4:53:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Alaskan Standard Time is 9/16/2020 6:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone UTC-09 is 9/16/2020 5:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Yukon Standard Time is 9/16/2020 7:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Pacific Standard Time (Mexico) is 9/16/2020 7:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone UTC-08 is 9/16/2020 6:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Pacific Standard Time is 9/16/2020 7:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone US Mountain Standard Time is 9/16/2020 7:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Mountain Standard Time (Mexico) is 9/16/2020 8:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Mountain Standard Time is 9/16/2020 8:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Central America Standard Time is 9/16/2020 8:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Central Standard Time is 9/16/2020 9:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Easter Island Standard Time is 9/16/2020 9:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Central Standard Time (Mexico) is 9/16/2020 9:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Canada Central Standard Time is 9/16/2020 8:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone SA Pacific Standard Time is 9/16/2020 9:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Eastern Standard Time (Mexico) is 9/16/2020 9:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Eastern Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Haiti Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Cuba Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone US Eastern Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Turks And Caicos Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Paraguay Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Atlantic Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Venezuela Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Central Brazilian Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone SA Western Standard Time is 9/16/2020 10:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Pacific SA Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Newfoundland Standard Time is 9/16/2020 11:53:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Tocantins Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone E. South America Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone SA Eastern Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Argentina Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Greenland Standard Time is 9/16/2020 12:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Montevideo Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Magallanes Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Saint Pierre Standard Time is 9/16/2020 12:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Bahia Standard Time is 9/16/2020 11:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone UTC-02 is 9/16/2020 12:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Mid-Atlantic Standard Time is 9/16/2020 1:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Azores Standard Time is 9/16/2020 2:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Cape Verde Standard Time is 9/16/2020 1:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone UTC is 9/16/2020 2:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone GMT Standard Time is 9/16/2020 3:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Greenwich Standard Time is 9/16/2020 2:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Sao Tome Standard Time is 9/16/2020 2:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Morocco Standard Time is 9/16/2020 3:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone W. Europe Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Central Europe Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Romance Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Central European Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone W. Central Africa Standard Time is 9/16/2020 3:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Jordan Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone GTB Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Middle East Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Egypt Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone E. Europe Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Syria Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone West Bank Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone South Africa Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone FLE Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Israel Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Kaliningrad Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Sudan Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Libya Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Namibia Standard Time is 9/16/2020 4:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Arabic Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Turkey Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Arab Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Belarus Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Russian Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone E. Africa Standard Time is 9/16/2020 5:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Iran Standard Time is 9/16/2020 6:53:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Arabian Standard Time is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Astrakhan Standard Time is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Azerbaijan Standard Time is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Russia Time Zone 3 is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Mauritius Standard Time is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Saratov Standard Time is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Georgian Standard Time is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Volgograd Standard Time is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Caucasus Standard Time is 9/16/2020 6:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Afghanistan Standard Time is 9/16/2020 6:53:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone West Asia Standard Time is 9/16/2020 7:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Ekaterinburg Standard Time is 9/16/2020 7:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Pakistan Standard Time is 9/16/2020 7:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Qyzylorda Standard Time is 9/16/2020 7:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone India Standard Time is 9/16/2020 7:53:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Sri Lanka Standard Time is 9/16/2020 7:53:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Nepal Standard Time is 9/16/2020 8:08:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Central Asia Standard Time is 9/16/2020 8:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Bangladesh Standard Time is 9/16/2020 8:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Omsk Standard Time is 9/16/2020 8:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Myanmar Standard Time is 9/16/2020 8:53:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone SE Asia Standard Time is 9/16/2020 9:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Altai Standard Time is 9/16/2020 9:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone W. Mongolia Standard Time is 9/16/2020 9:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone North Asia Standard Time is 9/16/2020 9:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone N. Central Asia Standard Time is 9/16/2020 9:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Tomsk Standard Time is 9/16/2020 9:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone China Standard Time is 9/16/2020 10:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone North Asia East Standard Time is 9/16/2020 10:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Singapore Standard Time is 9/16/2020 10:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone W. Australia Standard Time is 9/16/2020 10:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Taipei Standard Time is 9/16/2020 10:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Ulaanbaatar Standard Time is 9/16/2020 10:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Aus Central W. Standard Time is 9/16/2020 11:08:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Transbaikal Standard Time is 9/16/2020 11:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Tokyo Standard Time is 9/16/2020 11:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone North Korea Standard Time is 9/16/2020 11:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Korea Standard Time is 9/16/2020 11:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Yakutsk Standard Time is 9/16/2020 11:23:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone Cen. Australia Standard Time is 9/16/2020 11:53:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone AUS Central Standard Time is 9/16/2020 11:53:23 PM with a local time of 9/16/2020 10:23:23 AM Time in zone E. Australia Standard Time is 9/17/2020 12:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone AUS Eastern Standard Time is 9/17/2020 12:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone West Pacific Standard Time is 9/17/2020 12:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Tasmania Standard Time is 9/17/2020 12:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Vladivostok Standard Time is 9/17/2020 12:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Lord Howe Standard Time is 9/17/2020 12:53:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Bougainville Standard Time is 9/17/2020 1:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Russia Time Zone 10 is 9/17/2020 1:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Magadan Standard Time is 9/17/2020 1:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Norfolk Standard Time is 9/17/2020 1:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Sakhalin Standard Time is 9/17/2020 1:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Central Pacific Standard Time is 9/17/2020 1:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Russia Time Zone 11 is 9/17/2020 2:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone New Zealand Standard Time is 9/17/2020 2:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone UTC+12 is 9/17/2020 2:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Fiji Standard Time is 9/17/2020 2:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Kamchatka Standard Time is 9/17/2020 3:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Chatham Islands Standard Time is 9/17/2020 3:08:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone UTC+13 is 9/17/2020 3:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Tonga Standard Time is 9/17/2020 3:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Samoa Standard Time is 9/17/2020 3:23:23 AM with a local time of 9/16/2020 10:23:23 AM Time in zone Line Islands Standard Time is 9/17/2020 4:23:23 AM with a local time of 9/16/2020 10:23:23 AM
Thank you both,
This worked perfectly.