Different Date and Time Format

Home >> Dababase Interview Questions >> Sql Server 2005 Query

Posted on December 14th , 2009 by Admin

(1)How to get this format

Mon DD YYYY HH:MIAM (or PM)

SELECT CONVERT(VARCHAR(20), GETDATE(), 100)

MM/DD/YY

SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]

MM/DD/YYYY

SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]

YY.MM.DD

SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD]

YYYY.MM.DD

SELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [YYYY.MM.DD]

DD/MM/YY

SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]

DD/MM/YYYY

SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]

DD.MM.YY

SELECT CONVERT(VARCHAR(8), GETDATE(), 4) AS [DD.MM.YY]

DD.MM.YYYY

SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY]

DD-MM-YY

SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY]

DD-MM-YYYY

SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY]

DD Mon YY

SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY]

DD Mon YYYY

SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY]

Mon DD, YY

SELECT CONVERT(VARCHAR(10), GETDATE(), 7) AS [Mon DD, YY]

Mon DD, YYYY

SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY]

HH:MM:SS

SELECT CONVERT(VARCHAR(8), GETDATE(), 108)

Mon DD YYYY HH:MI:SS:MMMAM (or PM)

SELECT CONVERT(VARCHAR(26), GETDATE(), 109)

MM-DD-YY

SELECT CONVERT(VARCHAR(8), GETDATE(), 10) AS [MM-DD-YY]

MM-DD-YYYY

SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY]

YY/MM/DD

SELECT CONVERT(VARCHAR(8), GETDATE(), 11) AS [YY/MM/DD]

YYYY/MM/DD

SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY/MM/DD]

YYMMDD

SELECT CONVERT(VARCHAR(6), GETDATE(), 12) AS [YYMMDD]

YYYYMMDD

SELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD]

DD Mon YYYY HH:MM:SS:MMM(24h)

SELECT CONVERT(VARCHAR(24), GETDATE(), 113)

HH:MI:SS:MMM(24H)

SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)]