HOW TO CAST DATETIME in SQL SERVER

Hi,

Thank you for your co operation. Here the complete query:-

SELECT A0505.PNAME, A0052.FNAME AS DOCTOR, A0505.SLOTE as TIME,(CONVERT(VARCHAR(20),A0505.BKDATE,110)),A0505.PHONE  FROM A0505
INNER JOIN A0052 ON A0505.EMPCD=A0052.EMPCD WHERE A0505.SMSTATUS=0 AND A0052.ISACTIVE = 'y'

Try this code.

select CONVERT(VARCHAR(20),A0505.BKDATE,110) from A0505