Format Tanggal SQL Server

Mau bikin tampilan tanggal beda format ?
Contoh :
SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY]  -> 04 Jul 06
SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY] -> 04 Jul 2006
SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY] -> Jan 24, 1998
SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY] -> 01-01-2006
atau yang biasa, indonesia banget ..
SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY] -> 19/02/1972

masih banyak deh...lihat lengkapnya di sini.