Home Forums SQL Server 2005 SQL Server 2005 General Discussion convert the string value into varchar RE: convert the string value into varchar

  • December 9, 2009 at 2:53 am

    #1089701

    or this?

    Declare @string varchar(20)

    SET @string = '2009-Nov-11'

    SELECT datepart(m,CONVERT(datetime, @string))

    ---------------------------------------------------------------------------------