Fix date time format

When copying date time values from Sql Management Studio to Excel they come on this format


That's not recognized by Excel as a date time value. To fix this paste in notepad++ or another software that supports regular expression search and replace.

Replace this

with this:

The value becomes 20:56:46

No comments:

Post a Comment