Microsoft sql question...

html

let said i type

select name,convert(char(20),startdate,7) 'Start Date',dateadd(mm,6,startdate)+1 'Review Date' from emp

my question is how to format the Review date to appear in the format similar to Sixteenth of March 1999 (example here)

Anyone noe how to format it , i had try many times but still cannot

请使用中文发表！

[ 本帖最后由 白日梦 于 13-7-2006 12:13 PM 编辑 ]