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