database - Convert nvarchar to datetime in SQL Server 2008 arithmetic overflow

Question

I am trying to convert nvarchar values with the format 3/7/2013 to datetime but I can't quite figure it out. I am using SQL Server 2008 and keep getting an

Arithmetic overflow error converting expression to data type datetime

error.

Answer 1

This works fine:

SELECT CAST (N'3/7/2013' as datetime)