How to format datetime value to Mon.YY ?

Posted by Bandi on 7/1/2015 | Category: Sql Server Interview questions | Views: 2620 | Points: 40

Answer:

SELECT RIGHT(REPLACE(CONVERT(VARCHAR(9),GETDATE(), 6), ' ', '.'), 6) AS [Mon.YY]

Output:

Mon.YY
Jul.15

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Which of the following elements can you attach jQu ...

Next > : How to format datetime to MMM.YYYY format?

More Interview Questions by Bandi

Latest Interview Questions