Numeric Month - SQL, database, informix, oracle, SQL Server

Numeric Month

	Print
	Email

Submitted on: 8/22/2003 5:06:33 AM
By: Raghavendra Narayana
Level: Intermediate
User Rating:

By 6 Users
Compatibility:SQL Server 2000

Users have accessed this article 1805 times.

(About the author)

Here is a different way to get the month in number for character month. This is simple and you need not to use Date functions.

Terms of Agreement:
By using this article, you agree to the following terms...
1) You may use this article in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this article (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this article from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the article or article's description.

New Page 1

Here is a different way to get the month in number for character month.

This is simple and you need not to use Date functions.

--For first 3 characters of months

DECLARE @MONTHS AS CHAR(36)

SET @MONTHS = 'JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC'

SELECT (CHARINDEX('OCT', @MONTHS)/3)+1 AS NUMERIC_MONTH

--For all characters of months

DECLARE @MONTHS AS CHAR(108)

--IF CODE DOES NOT WORK PROPERLY

--CHECK WHETHER EVERY MONTH (INCLUDING THE SPACES) HAS 9 CHARACTER IN LENGTH

SET @MONTHS = 'JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBEROCTOBER NOVEMBER DECEMBER '

SELECT (CHARINDEX('DECEMBER', @MONTHS)/9)+1 AS NUMERIC_MONTH

Cheers,

Raghavendra_Narayana@hotmail.com

Other 9 submission(s) by this author

Report Bad Submission

Your Vote!

Other User Comments

8/25/2003 2:22:35 PM:Christina McEntire
This is a very simple & helpful way to pass in a month as a text-string and get the numeric month back. Thanks. I did find, however, that the "for all characters" version didn't work -- looks like maybe some of the spaces got stripped out. When I added the correct number of spaces for each month, it worked just fine. Christina

Add Your Feedback!

Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.

NOTICE: The author of this article has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular article, please click here.