Trim first two characters from year of GETDATE()

Question

Hello group, I am trying to create a WHERE clause that says

WHERE column_1 = TRIM(LEADING '20' FROM(DATEPART(year, GETDATE())))

Basically column_1 contains the fiscal year but the fiscal year is in the database as 8 or 9 not 2008 or 2009.

So I need to figure a way to trim off at least the '20' so that the query will run correctly... The more dynamic the better because I need to set this up to run in an SSIS pkg and the less hard coding the better.

Any suggestions? Thanks in advance! Jon

Answer 1

depending on the datatype of the column_1

print right(datepart(year,getdate()),2) --string with leading zero print convert(int,right(datepart(year,getdate()),2))--int

EDIT

based on @Richard's answer
print datepart(year,getdate()) % 100

Answer 2

Rather than trim, use modulus:

...
WHERE column_1 = (YEAR(GETDATE()) % 100)

Answer 3

Isn't there a convert format that will only print the last 2 digits of the year?

Answer 4

If your column is guaranteed to refer to years >= 2000 and < 2100, then you would get away with the rather obvious:

SELECT YEAR(GETDATE()) - 2000

But... Honestly, it would make me weep to see such code in a production environment. That's just a bit too much WTF, imo.