Solved

using datename function to return month in 3 character format

Posted on 2008-11-03
2
1,523 Views
Last Modified: 2012-06-22
I am using the datename function to return the month that an invoice was created, however, it returns full months, like January, February, etc.  Is there a way to return 3 character month names, like Jan, Feb, Mar, etc?   If not, is there a way to only pick up the first 3 characters in the month field?
Thanks, JoMar
0
Comment
Question by:JoMar
2 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
Comment Utility

select left(datename(m, getdate()),3)
0
 

Author Closing Comment

by:JoMar
Comment Utility
That worked - thanks much
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now