Select Convert(varchar, DOB , 107) as DOB FROM Table_Name
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)