Confused about formatting date

[eluser]umefarooq[/eluser]
Hi date_format is really easy to use it is like PHP date() function it will give you desired results if you day, month and year separate it can do so also and data processing will really speed up everything happen at database end, here is simple example, you have date 20/06/2010 and you want month out of it which 06 or June

Code:

date_format('20/06/2010','%M') will give you June

or you want output June-20 2010
date_format('20/06/2010','%M-%d %Y')

for more information about date_format check mysql documentation
date_format()