String to DateTime conversion in PowerShell

Question

I am trying to convert the time stamp value of a file to date time for comparing two date time differences.

The data would be coming in format 24122014_022257. I need to convert this into date time so that I can compare the values:

$usdate="24122014_022257"   
$dateParts = $usdate -split "_"   
$final = $dateparts[0] + $dateParts[1]

How can I do it?

mjolinor · Accepted Answer · 2015-01-02 12:04:23Z

32

You can use the ParseExact method:

[datetime]::ParseExact('24122014_022257','ddMMyyyy_HHmmss',$null)

Wednesday, December 24, 2014 2:22:57 AM

answered Jan 2, 2015 at 12:04

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

5 Comments

Ansgar Wiechers Over a year ago

Use [Globalization.CultureInfo]::InvariantCulture rather than $null. The latter will raise an error if for instance the format string has an AM/PM designator while your system's regional settings don't.

mjolinor Over a year ago

I usually just add the 'tt' specifier to the format string if I'm converting a data that uses AM/PM specifiers.

mjolinor Over a year ago

I don't see the point in adding an option to handle cultural differences in AM/PM designators doing a ParseExact on strings that don't have that designator.

miracle173 Over a year ago

On my system ` [datetime]::ParseExact('24/12/2014','dd/MM/yyyy',$null)` raises an exception but [datetime]::ParseExact('24/12/2014','dd/MM/yyyy',[Globalization.CultureInfo]::InvariantCulture) works fine.

Franklin Yu Over a year ago

@miracle173 That's weird; [DateTime]::ParseExact('24/12/2014','dd/MM/yyyy',$null) works just fine for me.

AdamL · Accepted Answer · 2015-01-02 12:07:50Z

10

ParseExact will do just that. You can specify custom datetime format in second parameter. You can leave third parameter as null, or specify a culture to use (it may matter if you're importing files that were generated from system with different time zone).

$usdate="24122014_022257"
[datetime]::ParseExact($usdate,"ddMMyyyy_HHmmss", [System.Globalization.CultureInfo]::CurrentCulture)

answered Jan 2, 2015 at 12:07

AdamL

13.3k5 gold badges57 silver badges79 bronze badges

Comments

Abhishek Singha · Accepted Answer · 2016-05-30 07:32:37Z

5

get-date 24122014022257

Wednesday, December 24, 2014 2:22:57 AM

answered May 30, 2016 at 7:32

Abhishek Singha

791 silver badge2 bronze badges

1 Comment

BikerP Over a year ago

For me this returns: 28 January 0001 22:03:21

Collectives™ on Stack Overflow

String to DateTime conversion in PowerShell

3 Answers 3

5 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related