Working with datetime variables
Posted: Thu Dec 08, 2011 8:31 am
Hello,
In datasets I would like to assign a date start of year to variable.
I wrote following SQL:
DECLARE @startOfYear datetime
select @startOfYear = cast(cast(YEAR(@EndDatePar) AS VARCHAR(4)) + '0101' AS datetime) --DATEADD(YEAR ,DATEDIFF(YEAR ,0 ,@EndDatePar) ,0)
but I receive error:
"Conversion failed when converting date and/or time from character string." on clicking Receive Columns.
@EndDatePar is a parameter associated with a variable which user enters and I'm working in Designer.
Would much appreciate your help.
In datasets I would like to assign a date start of year to variable.
I wrote following SQL:
DECLARE @startOfYear datetime
select @startOfYear = cast(cast(YEAR(@EndDatePar) AS VARCHAR(4)) + '0101' AS datetime) --DATEADD(YEAR ,DATEDIFF(YEAR ,0 ,@EndDatePar) ,0)
but I receive error:
"Conversion failed when converting date and/or time from character string." on clicking Receive Columns.
@EndDatePar is a parameter associated with a variable which user enters and I'm working in Designer.
Would much appreciate your help.