asked on

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

ASKER CERTIFIED SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

chapmandew

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. :)

SOLUTION

RemcovC

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JoMar

ASKER

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.

Guy Hengel [angelIII / a3]

>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...

chapmandew

RemcovC, Yes, I'm aware. Thank you. :)