By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,360 Members | 1,412 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,360 IT Pros & Developers. It's quick & easy.

How use the substring method with sql 2000?

P: 73
How Do i use the Substing method in sql 2000 if i have values from 1 to 12 and would like each of the numbers to repesent a month of the year.
Example
1 = January
2= Febuary
3 = March ....
Are there any other method that I could use to get the month back with sql from an integer value?
Jun 17 '08 #1
Share this Question
Share on Google+
3 Replies


debasisdas
Expert 5K+
P: 8,127
but how that function is going to help you in this scenario ?
Jun 18 '08 #2

ck9663
Expert 2.5K+
P: 2,878
use DATENAME. You have to hard code the day and year part. Since you're just interested in the month name, you can pick any day and year.

-- CK
Jun 19 '08 #3

P: 73
use DATENAME. You have to hard code the day and year part. Since you're just interested in the month name, you can pick any day and year.

-- CK
thanks I eventually got to that answer.
Jun 20 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.