string-to-datetime

Try this and See CAST and CONVERT (Transact-SQL) for more details.