SQL: Converting DateTime to MM/DD/YYYY Format 22. January 2010 Jon Blog (0) I tend to look this up quite a bit, so here it is for quick reference. This converts a datetime column into a MM/DD/YYYY format. UPDATE MyTable SET DateColumn2 = CONVERT(varchar(10), DateColumn1, 101)