How to show months from a sql view

I have a view that shows invoicing data from the past through today's date.  I used a datepart function to seperate the month out from the date of the invoice, however, it comes out as 1 through 12.  Is there a way to get the month to show up as either March or Mar vs. 3?
Thanks,
JoMar
JoMarAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
select datename(m, datefield)
from yourtable
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
check out DATENAME(month, yourdatefield) instead.
0
 
chapmandewCommented:
angelIII, are you suggesting that m in the datepart function doesn't work?  By the time difference of our responses I doubt that you are, just making sure.  :)
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
RemcovCConnect With a Mentor Commented:
@chapmandew

The syntax is: DATENAME ( datepart , date )
and the datepart for a month can either be m, mm, month

see: http://msdn.microsoft.com/en-us/library/ms174395.aspx
0
 
JoMarAuthor Commented:
Thanks to all - I awarded the most points to chapmandew since his came in first and was correct.  I also awarded some to angellll since he had the same thing and was also correct.  And I awarded som to RemcovC for the syntax information.  Great job to all and thanks.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>angelIII, are you suggesting that m in the datepart function doesn't work?  
as you assumed, I was responding to the questioner, and had not seen your post until I posted...
0
 
chapmandewCommented:
RemcovC, Yes, I'm aware.  Thank you.  :)
0
All Courses

From novice to tech pro — start learning today.