Seems to have rounded them all up by 1 day due to the time on the end? (some are probably ok though?) (confirm this)

If so it may be safer to just do a comparison against the date column and the correct calc to see which ones are wrong, then just update them with a dateadd -1 d (I can provide this if you can confirm the first question)

I tested the code provided above by Syed but had issues getting it to convert back and if it did it came out as 0000.0000?