Hi,

Try this... convert(varchar,cast(thisdate as datetime),6)

thisdate is the date u want to convert.

example: select convert(varchar,cast('2003-04-09 00:00:00.000' as datetime),6) will print

09 Apr 03

Hope this will solve ur problem,

Happy Programming

Gopal