How to get the month back from sql server 2000?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sheena777
    New Member
    • Dec 2007
    • 73

    #1

    How to get the month back from sql server 2000?

    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?
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    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

    Comment

    Working...