Standard Date Formats
|
SQL Statement
|
Sample Output
|
SELECT CONVERT(VARCHAR(20), GETDATE(), 100) |
Jan 1 2005 1:29PM 1
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY] |
11/23/98
|
SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY] |
11/23/1998
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD] |
72.01.01
|
SELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [YYYY.MM.DD] |
1972.01.01
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY] |
19/02/72
|
SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY] |
19/02/1972
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 4) AS [DD.MM.YY] |
25.12.05
|
SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY] |
25.12.2005
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY] |
24-01-98
|
SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY] |
24-01-1998
|
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(10), GETDATE(), 7) AS [Mon DD, YY] |
Jan 24, 98
|
SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY] |
Jan 24, 1998
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 108) |
03:24:53
|
SELECT CONVERT(VARCHAR(26), GETDATE(), 109) |
Apr 28 2006 12:32:29:253PM
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 10) AS [MM-DD-YY] |
01-01-06
|
SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY] |
01-01-2006
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 11) AS [YY/MM/DD] |
98/11/23
|
SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY/MM/DD] |
1998/11/23
|
SELECT CONVERT(VARCHAR(6), GETDATE(), 12) AS [YYMMDD] |
980124
|
SELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD] |
19980124
|
SELECT CONVERT(VARCHAR(24), GETDATE(), 113) |
28 Apr 2006 00:34:55:190
|
SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)] |
11:34:23:013
|
SELECT CONVERT(VARCHAR(19), GETDATE(), 120) |
1972-01-01 13:42:24
|
SELECT CONVERT(VARCHAR(23), GETDATE(), 121) |
1972-02-19 06:35:24.489
|
SELECT CONVERT(VARCHAR(23), GETDATE(), 126) |
1998-11-23T11:25:43:250
|
SELECT CONVERT(VARCHAR(26), GETDATE(), 130) |
28 Apr 2006 12:39:32:429AM
|
SELECT CONVERT(VARCHAR(25), GETDATE(), 131) |
28/04/2006 12:39:32:429AM
|