Convert date format into May 24, 2006

Hi All
How can i covert the date format into May 24, 2006
Below is what i have tried:
select CONVERT ( varchar(50) , getdate(), 101)
Thank you in advanceMittyKom,
Try using style 107.
select CONVERT ( varchar(50) , getdate(), 107)
go
AMB
"MittyKom" wrote:

> Hi All
> How can i covert the date format into May 24, 2006
> Below is what i have tried:
> select CONVERT ( varchar(50) , getdate(), 101)
> Thank you in advance