date format in sql
SELECT CONVERT(VARCHAR, GETDATE(),101) AS DATE SELECT CONVERT(VARCHAR, GETDATE(),102) AS DATE SELECT CONVERT(VARCHAR, GETDATE(),103) AS DATE SELECT CONVERT(VARCHAR, GETDATE(),104) AS DATE SELECT CONVERT(VARCHAR, GETDATE(),105) AS DATE SELECT CONVERT(VARCHAR, GETDATE(),106) AS DATE SELECT DATE = FORMAT(GETDATE(), 'dd-MM-yyyy')