Formatting datetime in powershell script

Question

I'm reading time into a variable from a CSV file but some of the time like 9 am is written as 9:00 instead of 09:00. How can I correct it into HH: mm format?

Santiago Squarzon · Accepted Answer · 2021-03-29 05:39:36Z

1

This should do the trick:

('9:00' -as [datetime]).ToString('HH:mm')

You can see it working on a loop from 0:00 to 12:00 with this:

PS /~> 0..12|%{("$_`:00" -as [datetime]).ToString('HH:mm')}
00:00 
01:00 
02:00 
03:00 
04:00 
05:00 
06:00 
07:00 
08:00 
09:00 
10:00 
11:00 
12:00

answered Mar 29, 2021 at 5:39

Santiago Squarzon

65.5k5 gold badges26 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

Formatting datetime in powershell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related