Extras
DATE only formats
Format # | Query | Format |
---|---|---|
1 | select convert(varchar, getdate(), 1) | mm/dd/yy |
2 | select convert(varchar, getdate(), 2) | yy.mm.dd |
3 | select convert(varchar, getdate(), 3) | dd/mm/yy |
4 | select convert(varchar, getdate(), 4) | dd.mm.yy |
5 | select convert(varchar, getdate(), 5) | dd-mm-yy |
6 | select convert(varchar, getdate(), 6) | dd-Mon-yy |
7 | select convert(varchar, getdate(), 7) | Mon dd, yy |
10 | select convert(varchar, getdate(), 10) | mm-dd-yy |
11 | select convert(varchar, getdate(), 11) | yy/mm/dd |
12 | select convert(varchar, getdate(), 12) | yymmdd |
23 | select convert(varchar, getdate(), 23) | yyyy-mm-dd |
101 | select convert(varchar, getdate(), 101) | mm/dd/yyyy |
102 | select convert(varchar, getdate(), 102) | yyyy.mm.dd |
103 | select convert(varchar, getdate(), 103) | dd/mm/yyyy |
104 | select convert(varchar, getdate(), 104) | dd.mm.yyyy |
105 | select convert(varchar, getdate(), 105) | dd-mm-yyyy |
106 | select convert(varchar, getdate(), 106) | dd Mon yyyy |
107 | select convert(varchar, getdate(), 107) | Mon dd, yyyy |
110 | select convert(varchar, getdate(), 110) | mm-dd-yyyy |
111 | select convert(varchar, getdate(), 111) | yyyy/mm/dd |
112 | select convert(varchar, getdate(), 112) | yyyymmdd |
TIME only formats
Format # | Query | Format |
---|---|---|
8 | select convert(varchar, getdate(), 8) | hh:mm:ss |
14 | select convert(varchar, getdate(), 14) | hh:mm:ss:nnn |
Last updated