raghuldrag (8/27/2012)
friends year is'2011-2012' data type is"nvarchar"while i am paasing inputs on procedure its shows error of
"error converting datetime from character string."
please give me any suggestion???
declare @DumbDateParameter nvarchar(9) = '2011-2012';
select
col1,
col2,
...,
coln
from
dbo.SomeTable
where
SomeDateCol >= dateadd(yy, cast(left(@DumbDateParameter,4) as int) - 1900, 0) and
SomeDateCol < dateadd(yy, cast(right(@DumbDateParameter,4) as int) - 1899, 0);