Monday 20 June 2016

MSSQL - Update Date Only - Keep orgial time

Watch this example on YouTube

Update TestTable Set
OrderDate = DateAdd(day, DateDiff(day, OrderDate, '1/1/2016'), OrderDate)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)