I moved data from one database to another, one of the fields that was moved is a date and put into a varchar field. I won't get into details but it has to be like that.
Right now it displays the date as: Jan 1 2014 12:00AM
I need to update the whole column for all records so that it reads as: mm/dd/yyyy (01/01/2014)
SQL Something like:
set DOB = NEW value where DOB = 'current value'
Help is appreciated