1SELECT CONVERT(VARCHAR, GETDATE(),101) AS DATE
2SELECT CONVERT(VARCHAR, GETDATE(),102) AS DATE
3SELECT CONVERT(VARCHAR, GETDATE(),103) AS DATE
4SELECT CONVERT(VARCHAR, GETDATE(),104) AS DATE
5SELECT CONVERT(VARCHAR, GETDATE(),105) AS DATE
6SELECT CONVERT(VARCHAR, GETDATE(),106) AS DATE
7
8SELECT DATE = FORMAT(GETDATE(), 'dd-MM-yyyy')
9
1DATE - format YYYY-MM-DD
2DATETIME - format: YYYY-MM-DD HH:MI:SS
3TIMESTAMP - format: YYYY-MM-DD HH:MI:SS
4YEAR - format YYYY or YY