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

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

Accepted Answer

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