Convert string datetime2(7) to datetime Format in PowerShell

Описание: Learn how to convert a string in `datetime2(7)` format to a proper datetime format in PowerShell. Follow our step-by-step guide for effective solutions.
---
This video is based on the question https://stackoverflow.com/q/63483058/ asked by the user 'Rajendar Talatam US - IFS' ( https://stackoverflow.com/u/12641126/ ) and on the answer https://stackoverflow.com/a/63485602/ provided by the user 'philmph' ( https://stackoverflow.com/u/14100666/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: convert given string datetime2(7) in powershell

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Converting string datetime2(7) in PowerShell: A Simple Guide

When working with PowerShell, you may encounter situations where you need to convert date and time strings into more usable formats. One common scenario is converting a string in the datetime2(7) format, which includes fractions of seconds, for easier data manipulation. In this guide, we will explore how to convert the string 2020-08-19T08:00:53.643Z into the datetime2(7) format of 2020-01-20 21:10:11.4866667. Let’s dive into the details!

The Problem

You have a date-time string in the format 2020-08-19T08:00:53.643Z, but you need to transform it into a specific format, yyyy-MM-dd HH:mm:ss.fffffff. This new format is crucial for various applications, particularly when dealing with databases that require exact timestamp formats.

The Solution

Step 1: Understanding the Current Format

The string you are dealing with follows a standard ISO 8601 format:

Date: 2020-08-19

Time: 08:00:53.643

Z: Indicates that the time is in UTC (Coordinated Universal Time).

Step 2: Use PowerShell to Convert the Datetime Format

PowerShell provides built-in capabilities to parse date-time strings effectively. Instead of manually constructing the date-time object, you can use the [datetime]::Parse() method, which simplifies the process significantly.

Step 3: Implement the Solution

Here’s how you can implement the solution in PowerShell:

[[See Video to Reveal this Text or Code Snippet]]

Explanation of Each Step

Store the Date-Time String: This is your starting point, where you define the date-time string you want to convert.

Parse the String: The [datetime]::Parse($temp) creates a DateTime object from your string. PowerShell automatically interprets the time zone thanks to the Z at the end of your string.

Format the Output: The .ToString("yyyy-MM-dd HH:mm:ss.fffffff") method reformats the DateTime object into your desired string format.

Output the Result: Finally, the last line prints the reformatted date-time string.

Example Result

When you run the above PowerShell script, the output will be:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

Transforming date-time strings in PowerShell is not just feasible but can be done quickly using built-in methods. The approach we outlined provides a reliable way to convert strings into the required formats for your applications. By understanding how to utilize the [datetime] class's parsing capabilities, you can handle date-time formatting tasks with ease.

For more sophisticated date-time manipulations and conversions, continue to explore PowerShell’s extensive datetime functionalities. Happy scripting!