select last two year from current year

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sharath.chalamgari SSCertifiable Points: 5680 More actions · Answer 1

you can simply try like this

select year(getdate())- 2

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 2

Hi purushot,, try these:

SELECT

DATEADD(YY, -2 , GETDATE()) AS [2_YRS_BACK_FULLDATE] ,

(DATEPART(YY,GETDATE()) + 2) AS ADD_2YRS

purushotham.k9 SSCommitted Points: 1992 More actions · Answer 3

SSCommitted

Points: 1992

May 27, 2010 at 6:09 am

Thanks

Cadavre SSC-Forever Points: 41690 More actions · Answer 4

Without DDL, it's difficult to answer your question. I'd do something like this, if using DATETIME -

DECLARE @currentdate DATETIME,

@lastyear DATETIME,

@twoyearsago DATETIME

SET @currentdate = Getdate()

SET @lastyear=Dateadd(yyyy, -1, @currentdate)

SET @twoyearsago=Dateadd(yyyy, -2, @currentdate)

SELECT @currentdate AS [CurrentDate],

@lastyear AS [1 Year Previous],

@twoyearsago AS [2 Years Previous]

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 5

SSC-Dedicated

Points: 39972

May 27, 2010 at 6:16 am

purushotham.k9 (5/27/2010)
Thanks

You're welcome!