I am trying to cast from nvarchar to datetime as follows:
SET myDateTime = cast([nvarchar255DateTime] as datetime)
Getting the following SQL scripting error:
Msg 242, Level 16, State 3, Line 3
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.
sample data for nvarcharDateTime: 01/10/2010