sql2008-characters to numbers cast and convert

Grammar
Using cast:
CAST (expression as data_type)

Using convert:
CONVERT (data_type[(length)],expression,[style])
Cases:
CONVERT (VARCHAR), GETDATE (), 120)
120 or Yyyy-mm-dd Hh:mi:ss (24h) {2012-08-12 17:26:11}
121 or Yyyy-mm-dd hh:mi:ss.mmm (24h) {2012-08-12 17:26:11.000}

Style ID	Style Format
100 or 0	Mon dd yyyy hh:miam (or PM)
101	Mm/dd/yy
102	Yy.mm.dd
103	Dd/mm/yy
104	Dd.mm.yy
105	Dd-mm-yy
106	DD Mon yy
107	Mon DD, yy
108	Hh:mm:ss
109 or 9	Mon dd yyyy hh:mi:ss:mmmAM (or PM)
110	Mm-dd-yy
111	Yy/mm/dd
112	Yymmdd
113 or 13	DD Mon yyyy hh:mm:ss:mmm (24h)
114	Hh:mi:ss:mmm (24h)
120 or 20	Yyyy-mm-dd Hh:mi:ss (24h)
121 or 21	Yyyy-mm-dd hh:mi:ss.mmm (24h)
126	Yyyy-mm-ddthh:mm:ss.mmm (no spaces)
130	DD Mon yyyy hh:mi:ss:mmmAM
131	Dd/mm/yy Hh:mi:ss:mmmAM

sql2008-characters to numbers cast and convert