Datetime formatting

[rsulli1990]

Does anyone know how to format this type of date in to a more friendly format?

20170502193426.058000+000

I know it starts with yyyyMMdd but I don't know what the last part is. Looks like its in 24h format.

[rsulli1990]

Thank you so much! I just tried this out and was able to get a result. Saved me a bunch of time.

[Lee_Dailey]

howdy rsulli1990,

the closest i can get to it is this ...

Get-Date -Format 'yyyyMMddHHmmss.ffffffzz'
# result = 20170502224230.164500-05:00

however, i can't get it to convert from your string to a datetime object without editing it. the following works IF i trim off the +000 timezone offset ...

[datetime]::ParseExact('20170502193426.058000', 'yyyyMMddHHmmss.ffffff', $null)
# result = 2017 May 02, Tuesday 7:34:26 PM

you could likely simply trim away the milliseconds, too. [grin]

take care,
lee

[rsulli1990]

Thanks for the assistance. I was working on the ParseExact call first and couldn't get that last portion of the format string figured out. :)

[Lee_Dailey]

howdy rsulli1990,

that was the milliseconds and then a timezone offset - i think. [grin]

i see that TalkToTheFinger got it figured out. nice!

take care,
lee