How do I get month NAME from a date?

#1

Not sure if this is the right forum for this, but I'm trying to extract the
month name (e.g. April) from a date in SQLServer. I know I can use DatePart
to get the month number. Is there an easy way to get the name, or do I need
to write code to convert?

Thanks

#2

Quote:

-----Original Message-----
Not sure if this is the right forum for this, but I'm
trying to extract the
month name (e.g. April) from a date in SQLServer. I know
I can use DatePart
to get the month number. Is there an easy way to get the
name, or do I need
to write code to convert?

Thanks

.You can use DATENAME

Quote:

#3

You can use DATENAME function

Quote:

-----Original Message-----
Not sure if this is the right forum for this, but I'm
trying to extract the
month name (e.g. April) from a date in SQLServer. I know
I can use DatePart
to get the month number. Is there an easy way to get the
name, or do I need
to write code to convert?

Thanks

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I get month NAME from a date?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How do I get month NAME from a date? - 04-07-2004 , 08:56 AM

How do I get month NAME from a date? - 04-07-2004 , 09:32 AM

How do I get month NAME from a date? - 04-07-2004 , 09:35 AM