Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Friday, January 21, 2011

Different Date and Time Format

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

No comments :

Post a Comment