HI FRIEND,
These may help you,just change only the last argument and see the output in sql
SELECT CONVERT(VARCHAR(10),GETDATE(),110)
SELECT CONVERT(VARCHAR(10),GETDATE(),100)
SELECT CONVERT(VARCHAR(10),GETDATE(),102)
Please once you check the below link,
http://www.w3schools.com/sql/func_convert.asp[
^]