How to get year in format YY in SQL Server in asp.net C#

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

There are 2 ways:

select right(year(getdate()),2)
select year(getdate()) % 100

Answer 2

There are more than 2 ways, 2 of which are:

SELECT RIGHT(YEAR(Creation_Date),2)
FROM Asset_Creation 
WHERE Creation_Date = @Creation_Date


SELECT SUBSTRING(YEAR(Creation_Date),3,2)
FROM Asset_Creation 
WHERE Creation_Date = @Creation_Date