convert the string value into varchar

Home

Author

Message

Posted Wednesday, December 09, 2009 2:27 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 08, 2010 7:22 AM
Points: 46, Visits: 107

I need a help to convert string value into dateformat. like i have a string like '2009-NOV' i want to retrive month after converting dateformat...

Post #831220

Posted Wednesday, December 09, 2009 2:51 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 4:08 AM
Points: 356, Visits: 1,666


declare @i varchar(25)
set @i='2009-NOV'
select datename(month,cast(@i as datetime))

Post #831234

Posted Wednesday, December 09, 2009 2:53 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 02, 2011 3:36 AM
Points: 579, Visits: 1,803

or this?

Declare @string varchar(20)
SET @string = '2009-Nov-11'

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

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

Post #831236

Permissions