SQL Server DateTime Formats

The list of styles that can be applied are:

SQL Style ID	SQL Style	Example
0 or 100	mon dd yyyy hh:miAM (or PM)	Jan 15 2008 5:44PM
101	mm/dd/yy	01/15/2008
102	yy.mm.dd	2008.01.15
103	dd/mm/yy	15/01/2008
104	dd.mm.yy	15.01.2008
105	dd-mm-yy	15-01-2008
106	dd mon yy	15 Jan 2008
107	Mon dd, yy	Jan 15, 2008
108	hh:mm:ss	17:42:33
9 or 109	mon dd yyyy hh:mi:ss:mmmAM (or PM)	Jan 15 2008 5:42:09:953PM
110	mm-dd-yy	01-15-2008
111	yy/mm/dd	2008/01/15
112	yymmdd (no spaces)	20080115
13 or 113	dd mon yyyy hh:mm:ss:mmm(24h)	15 Jan 2008 17:37:13:163
114	hh:mi:ss:mmm(24h)	17:37:52:407
20 or 120	yyyy-mm-dd hh:mi:ss(24h)	2008-01-15 17:38:20
21 or 121	yyyy-mm-dd hh:mi:ss.mmm(24h)	2008-01-15 17:38:44.867
126	yyyy-mm-dd Thh:mm:ss.mmm(no spaces)	2008-01-15T17:39:12.193