The SQL Server has inbuilt function to convert string to date. It can be done using CAST/CONVERT as shown below

sql server function to convert string to date

There are other formats available in convert function. To get more detail refer to http://msdn.microsoft.com/en-us/library/ms187928.aspx

 

Regards

Ahmad Osama

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook