DateName( ) Issue

[ChopinFan]

I need to get the DateName(Month, QuotaMonth), where QuotaMonth is only the integer of the month (an integer 1 through 12) and not the entire date. How can I best do this?

Thanks!

 

[SQLDenis]

use datepart

select datename(month,getdate())
select datepart(month,getdate())

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ChopinFan]

This only returns the integer, which I already have. I need the text.

Thanks!

 

[ChopinFan]

I forgot to say.... I can only give the datename function an integer, not a date, so

Select datename(month, QuotaMonth) doesn't work.

 

[SQLDenis]

???

this
select datename(month,getdate())
select datepart(month,getdate())

returns

November
11

so if you want the text then use datename
select datename(month,getdate())

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

Okay fair enough take a look at this

select datename(m,dateadd(m,1-1,0))
select datename(m,dateadd(m,2-1,0))
select datename(m,dateadd(m,3-1,0))

so in your case

select datename(m,dateadd(m,QuotaMonth -1,0))


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ChopinFan]

Thanks, but you're using getdate(), which I'm not. I only have an integer to use. For example, the QuotaMonth may be 10, but I need to display the month text October instead.

Help!

 

[SQLDenis]

refresh please ;-)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ChopinFan]

Looks good, thanks much!