Q:

Convert nvarchar to datetime in SQL Server 2008 arithmetic overflow

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.

A:

This works fine: 
SELECT CAST (N'3/7/2013' as datetime)

