Get the 2 digit year in T-SQL

Question

I need to get the current 2 digit year and increment by one. So the current number I'm looking for should be 11.

Probably really simple but I'm a sql noob :)

Thanks

Answer 1

You can do ( YEAR( GETDATE() ) % 100 ) + 1

See GETDATE & YEAR

Answer 2

This will work for you

select Right(Year(getDate())+ 1,2)

Answer 3

SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 1),2) as YEAR