Date Format

Hi,

I want my query should return a content of date field in 'MMM-YYYY' format.

Can Anyone help me to get this

You may use Year() and Month() functions alongside the convert() function.|||

There is no built in function to do that. You can use the date functions like datename to get theappropiate results.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de