|
Date Formats : |
|
Format # |
Query |
Output |
|
1 |
SELECT convert(VARCHAR, getdate(), 1) |
02/20/10 |
|
2 |
SELECT convert(VARCHAR, getdate(), 2) |
10.02.20 |
|
3 |
SELECT convert(VARCHAR, getdate(), 3) |
20/02/10 |
|
4 |
SELECT convert(VARCHAR, getdate(), 4) |
20.02.10 |
|
5 |
SELECT convert(VARCHAR, getdate(), 5) |
20-02-10 |
|
6 |
SELECT convert(VARCHAR, getdate(), 6) |
20 Feb 10 |
|
7 |
SELECT convert(VARCHAR, getdate(), 7) |
Feb 20, 10 |
|
10 |
SELECT convert(VARCHAR, getdate(), 10) |
02-20-10 |
|
11 |
SELECT convert(VARCHAR, getdate(), 11) |
02-20-10 |
|
101 |
SELECT convert(VARCHAR, getdate(), 101) |
02/20/2010 |
|
102 |
SELECT convert(VARCHAR, getdate(), 102) |
2010.02.20 |
|
103 |
SELECT convert(VARCHAR, getdate(), 103) |
20/02/2010 |
|
104 |
SELECT convert(VARCHAR, getdate(), 104) |
20.02.2010 |
|
105 |
SELECT convert(VARCHAR, getdate(), 105) |
20-02-2010 |
|
106 |
SELECT convert(VARCHAR, getdate(), 106) |
20 Feb 2010 |
|
107 |
SELECT convert(VARCHAR, getdate(), 107) |
Feb 20, 2010 |
|
110 |
SELECT convert(VARCHAR, getdate(), 110) |
02-20-2010 |
|
111 |
SELECT convert(VARCHAR, getdate(), 111) |
2010/02/20 |