How do I get month NAME from a date? -- sql server dts

sam.moayedi NO[at]SPAM moneymanagement.org
4/7/2004 7:32:23 AM

[quoted text, click to view]

anonymous NO[at]SPAM discussions.microsoft.com
4/7/2004 7:35:30 AM

You can use DATENAME function

[quoted text, click to view]

Maria
4/7/2004 9:56:24 AM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : How do I get month NAME from a date?