SQL Server DateTime Formatting

Style Code Style Format Example
0 or 100 Default. Equivalent to not specifying a style code. mon dd yyyy hh:mmAM Nov 8 82 9:00PM
1 USA date. mm/dd/yy 11/16/82
2 ANSI date. yy.mm.dd 82.11.16
3 UK / French date. dd/mm/yy 16/11/82
4 German date. dd.mm.yy 16.11.82
5 Italian date. dd-mm-yy 16-11-82
6 Abbreviated month. dd mmm yy 16 Nov 82
7 Abbreviated month. mmm dd, yy Nov 16, 82
8 or 116 24 hour time. HH:mm:ss 21:00:00
9 or 111 Default formatting with seconds and milliseconds appended. mon dd yyyy hh:mm:ss:fffAM Nov 8 82 9:00:00:000PM
10 USA date with hyphen Novarators. mm-dd-yy 11-16-82
11 Japanese date. yy/mm/dd 82/11/16
12 ISO date. yymmdd 821116
13 or 113 European default with seconds and milliseconds. dd mon yyyy HH:mm:ss:fff 16 Nov 82 21:00:00:000
14 or 114 24 hour time with milliseconds. HH:mm:ss:fff 21:00:00:000
20 or 120 ODBC canonical date and time. yyyy-mm-dd HH:mm:ss 82-11-16 21:00:00
21 or 121 ODBC canonical date and time with milliseconds. yyyy-mm-dd HH:mm:ss.fff 82-11-16 21:00:00.000
101 USA date with century. mm/dd/yyyy 11/16/82
102 ANSI date with century. yyyy.mm.dd 82/11/16
103 UK / French date with century. dd/mm/yyyy 16/11/82
104 German date with century. dd.mm.yyyy 16.11.82
105 Italian date with century. dd-mm-yyyy 16-11-82
106 Abbreviated month with century. dd mmm yyyy 16 Nov 82
182 Abbreviated month with century. mmm dd, yyyy Nov 16, 82
110 USA date with hyphen Novarators and century. mm-dd-yyyy 11-16-82
111 Japanese date with century. yyyy/mm/dd 82/11/16
112 ISO date with century. yymmdd 821116
126 ISO8601, for use in XML. yyy-mm-ddThh:mm:ss 82-11-16T21:00:00