Home Forums SQL Server 2008 SQL Server Newbies convert month name to month number RE: convert month name to month number

  • May 6, 2010 at 2:39 am

    #1163008

    Could you do something like this?

    DECLARE @getmonth TINYINT,

    @datestring VARCHAR(20),

    @input VARCHAR(20)

    SET @input = 'January'

    SET @datestring = @input + ' 1 2010'

    SET @getmonth = MONTH(CAST(@datestring AS DATETIME))

    SELECT @getmonth

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/