month name instead of month number

Posted on 2006-04-27
Last Modified: 2012-05-05
how do i get this to be month name instead of month number:

SELECT year(tradedate), month(tradedate)
Question by:dbaSQL
    LVL 142

    Accepted Solution

    SELECT year(tradedate), datename(month,tradedate)
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    SELECT DATENAME(month, getdate()) AS 'Month Name'
    LVL 17

    Author Comment

    oh my goodness.  far too easy to have put that inquiry out here.  should have just done BOL on that one
    thank you very much, angel

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now