How to get abbreviated Month 1

[sconti11]

Below is the code I am currently using:

DATENAME(Month, DATEADD(Month, Month - 1, 0)) AS MonthName

This gives me the Month as January, I need to abbreviate that to just Jan.

Is there a quick way to do this?

 

[gmmastros]

The abbreviations for all of the months happens to be the first 3 characters of the full month name, so....

[tt][!]Left([/!]DATENAME(Month, DATEADD(Month, Month - 1, 0))[!], 3)[/!] AS MonthName[/tt]

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[ousoonerjoe]

Simple answer:

	SELECT LEFT(DATENAME(MONTH, DATEADD(MONTH, Month - 1, 0)), 3) AS MonthName

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------

 

[gmmastros]

I should modify my answer....

The month abbreviations are the first 3 letters of the full month name for the English language. This is not necessarily true for other languages.

To see a list of abbreviations, you can run this query.

Select name, alias, months, shortmonths
from   sys.syslanguages

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[sconti11]

Awsome!

Kudos to both gmmastros and ousoonerjoe!

 

[sparkbyte]

Take a look here.

http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/

Thanks

John Fuhrman

 

[djj55]

John (sparkbyte), nice link.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!