--Date--SELECT CONVERT(VARCHAR(20), GETDATE(), 100)SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]  SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD]SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]SELECT CONVERT(VARCHA... [More]