SQL Server CONVERT() Function
CONVERT() function is demonstrated with examples. More on the topic in the new book:
Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012
Kalman Toth
ISBN: 1479156043
Available on amazon in paperback & kindle.