I am getting the following error message when attempting to sort results by a datetime column:
"Msg 242, Level 16, State 3, Line 1
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value"
here is the query:
select top 100 *
FROM
order by[Event_End]
I'm even getting this error while trying to track down this error...
select *
FROM
where ISDATE([event_end])=0
"Msg 242, Level 16, State 3, Line 1
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value."
This is on SQL Server 2008.
can anyone try to help me track this down?
"Msg 242, Level 16, State 3, Line 1
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value"
here is the query:
select top 100 *
FROM
order by[Event_End]
I'm even getting this error while trying to track down this error...
select *
FROM
where ISDATE([event_end])=0
"Msg 242, Level 16, State 3, Line 1
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value."
This is on SQL Server 2008.
can anyone try to help me track this down?