--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]