How can I query to get a date field formatted in a specific date format string? For example, I would like the query to return "June 15, 2009".

When I query
SELECT MyDate FROM MyTable
I get '6/15/2009'

When I query
SELECT {fn CONVERT(MyDate, SQL_VARCHAR)} FROM MyTable
I get '2009-06-15'

Any suggestions?