>Hii I am using Sql SERver 2005 i have a query which is returning
>
>date as '2012-07-15 00:00:00'
>
>I want to show this date as 15 July 2012
>
>How could i do this.. Thanks
Where do you want to display date like this? Did you look into possible date time formats in .NET?
In T-SQL take a look at CONVERT function in BOL to return formatted date as a string.
If it's not broken, fix it until it is.
My Blog