How to get year in format YY in SQL Server
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?
No comments:
Post a Comment