2011/01/22

Fix date time format

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


20:56:46.433


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
(:[0-9][0-9])(\.[0-9][0-9][0-9])\t


with this:
\1\t


The value becomes 20:56:46

No comments:

Post a Comment