DECLARE @datefrom DateTime SET @datefrom = '30/11/2013 00:00:00'
SELECT [events].datefrom, [events].* FROM [events] WHERE [events].live > 0 AND [events].deleted < 1 AND (@datefrom <= datefrom OR @datefrom is null OR @datefrom = '')
WHEN running this in SQL, this flashes a list of the events with the date filter then reports:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
(852 row(s) affected).
I'm confused, I don't know what is going on? I got the '30/11/2013 00:00:00' from .net datetime SQL parameter type
DECLARE @datefrom DateTime SET @datefrom = '20131130' -- YYYYMMDD SELECT @datefrom what is the datatype of column datefrom ? If VARCHAR, first convert datefrom to datetime in the WHERE clause
DateTime error
Posted - 09/01/2013 : 15:27:45
