MySQL Forums
Forum List  »  Knowledge Base

How to display months with year using mysql query ?
Posted by: vinoth manickam
Date: May 30, 2009 12:36AM

Hi,
I am using mysql5.0.I need query for display in months wise with year also.

For example : I need months April 2009 , March 2009 , Febuaury 2009 , january 2009 , december 2008 , november 2008 , octomber 2008, september 2008 , august 2008 , july 2008 , june 2008,may 2008. likewise also..next month from may 2009 to july 2008.

current month to 11 months only.


How to write query for that ..Please help me.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to display months with year using mysql query ?
4017
May 30, 2009 12:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.