CONVERT DATE TYPE TO VACHAR IN SQL SERVER : HOW DO I CONVERT A ENDDATE COLOUMN WHICH IS DATE TYPE TO VARCHAR IN SQL SERVER ?

E.G      ENDDATE(DATE TYPE)
    '1947-12-01 00-00-00' 

TO        ENDDATE(VARCHAR)
          121947
