If you are wondering how to perform date/string conversions on SQL Server, Gianluca Sartori wrote a very nice technical article on www.sqlservercentral.com. I really recommend you to read the article, it will provide you with enough information to decide on which way to perform the conversion. You can find the article here and also here, in the last link you would be able to download the code. Enjoy 😉
Date/String conversions on SQL Server
Published by
isalom
I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I'm a Systems Engineer graduated from The Hague University (http://www.thehagueuniversity.com/). I have been working in IT for over 15 years. Since November 2014 I started www.cenlinea.com a webportal were the focus is to make learning more fun. At Cenlinea we are currently promoting PLAYDIOM a new methodology to learn English. While currently working part-time time at Cenlinea, I am also working as Senior Princiapal Consultant at www.ccgroep.com which helps me to keep up to date with Microsoft SQL Server, which I consider to be one of my favorite things in life as it has changed my life in many ways. I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com View all posts by isalom
IgnacioSalom.com 
Thanks for the kind words, Ignacio.
See you around the forums!