How can I convert a varchar field of the form: YYYYMMDD to a datetime in T-SQL?

Question

How can I convert a varchar field of the form YYYYMMDD to a datetime in T-SQL?

Thank you.

Answer 1

select convert(datetime, '20081030')