How to convert from string to date?

We can use the convert function

SELECT [Datetime] = CONVERT(datetime,'2010-02-28')

For more formats refer http://www.sqlusa.com/bestpractices2005/sqlserverstringtodate/