sql server year

Question

Hi all...

DECLARE @FINANCIALYEAR AS varchar(30)
DECLARE @FINALFINANCIALYEAR AS int

SELECT @FINANCIALYEAR=CONVERT(VARCHAR,YEAR(GETDATE())-2) + ', ' +  
CONVERT(VARCHAR,YEAR(GETDATE())-1) + ', ' +  
CONVERT(VARCHAR,YEAR(GETDATE())) 

set @FINALFINANCIALYEAR = CONVERT(int,@FINANCIALYEAR)
print @FINALFINANCIALYEAR

i want final output in int format so iam doing above code but it gives me error plz help

Answer 1

Select YEAR (GetDate())-2,YEAR (GetDate())-1, YEAR (GetDate())

Answer 2

SELECT DATEPART(YEAR, GETDATE()), DATEPART(YEAR, GETDATE()) - 1, DATEPART(YEAR, GETDATE()) - 2

Answer 3

this year is

Select datepart(year,getdate())

or

year(getdate())

Answer 4

Simple query

SELECT CONVERT(VARCHAR,YEAR(GETDATE())-2) + ', ' + 
CONVERT(VARCHAR,YEAR(GETDATE())-1) + ', ' + 
CONVERT(VARCHAR,YEAR(GETDATE()))

Answer 5

Just check what your variable is after your SELECT:

DECLARE @FINANCIALYEAR AS varchar(30)
DECLARE @FINALFINANCIALYEAR AS int

SELECT @FINANCIALYEAR=CONVERT(VARCHAR,YEAR(GETDATE())-2) + ', ' +  
CONVERT(VARCHAR,YEAR(GETDATE())-1) + ', ' +  
CONVERT(VARCHAR,YEAR(GETDATE())) 

SELECT @FINANCIALYEAR

The output is:

2008, 2009, 2010

This is clearly NOT a valid INT value - so it's obvious you're getting a conversion error.....