HOW TO CAST DATETIME in SQL SERVER

Question

Hi Sir I need your help to cast a SQL SP . Please take a look to the column: AO505. BKDATE. I want to display this as dd-mm-yyyy. Please help me

Lakshmanan Sethu · Answer

Nathan Is it working now?

Nathan R · Answer

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.BKDATE110))A0505.PHONE FROM A0505 INNER JOIN A0052 ON A0505.EMPCD=A0052.EMPCD WHERE A0505.SMSTATUS=0 AND A0052.ISACTIVE = 'y'

Kalai · Answer

Try this code. select CONVERT(VARCHAR(20)A0505.BKDATE110) from A0505

Lakshmanan Sethu · Answer

Hi Nathan Please use below cast CONVERT(varchar(11)A0505.BKDate103)