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

How to get the month back from sql server 2000?

P: 73
I am getting the month back from a sql select query and would now like to change the number value into the text so that I can get the month value back. Example January , Febuary etc. How would I do This?
Jun 17 '08 #1
Share this Question
Share on Google+
1 Reply

code green
Expert 100+
P: 1,726
SQL server supports months in the format mmm - Jan Feb etc
I think you may need to employ a look up table if you require January, February.
There may be a VBscript or C function that can be employed but I have never come across it
Jun 17 '08 #2

Post your reply

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