How to get year in format YY in SQL Server

Question

select Year(Creation_Date) 
from Asset_Creation 
where Creation_Date = @Creation_Date

I am executing this query where I am getting year as 2013 when supplied today's date. I want the query to return only 13 of 2013. How can I achieve that?

Answer 1

Try

SELECT RIGHT(YEAR(Creation_Date), 2) YY 
  FROM Asset_Creation 
 WHERE ...

Sample output:

| YY |
------
| 10 |
| 11 |
| 13 |

Here is SQLFiddle demo