Help in Script - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Help in Script

Author

Topic

kenny_gua
Starting Member

1 Post

Posted - 2008-08-04 : 14:13:40

I ran the following script but @prevYear showing 1905-year which is wrong.

@Currentyear should be current date like 'Aug 4 2008 12:17PM' and @PrevYear date should be -2 year from current date like 'Aug 4 2006 12:17PM' . Can you please help to provide the right script.

Script
--------
DECLARE @Currentyear datetime
DECLARE @PrevYear datetime
SELECT @Currentyear =getdate()
SELECT @PrevYear =year(dateadd(yy,-2,getdate()))

print @Currentyear
print @PrevYear

Results from the above script:

-----------------------------------------

Aug 4 2008 12:17PM
Jun 30 1905 12:00AM

My desired results. How can I get following results from the above script

--------------------------

Aug 4 2008 12:17PM
Aug 4 2006 12:17PM

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-04 : 14:31:22

you need just this
SELECT @PrevYear =dateadd(yy,-2,getdate())

shakilhyd
Starting Member

16 Posts

Posted - 2008-08-04 : 17:47:13

Thanks so much.

quote:
Originally posted by visakh16

you need just this
SELECT @PrevYear =dateadd(yy,-2,getdate())

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources