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 pm
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,200 8
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
yymmdd (no spaces)
13 or 113	dd mon yyyy hh: mm: SS: Mmm (24 h)	15 Jan 2008 17: 37: 13: 163
hh: MI: SS: Mmm (24 h)	17: 37: 52: 407
20 or 120	yyyy-mm-dd hh: MI: SS (24 h)	17:38:20
21 or 121	yyyy-mm-dd hh: MI: Ss. mmm (24 h)	17:38:44. 867
yyyy-mm-dd thh: mm: Ss. mmm (no spaces)	2008-01-15t17: 39: 12.193