MySQL Forums :: Newbie :: problem for selecting range of date between 2 dates


Advanced Search

problem for selecting range of date between 2 dates
Posted by: Mohammad Qamar ()
Date: March 12, 2012 06:35AM

Hi

I used to select a range of data between 2 dates from a table in a created database using mysql

the problem is: the person who created the database distributed the dates into 2 columns of type SMALLINT instead of one column of type date, one column for the month and the other for the year

I want to select all data which in between 10-2011 and 2-2012 (date format is mm-yyyy)

any idea how can I write the query of selection?

please help me, it is an urgent task

thank you

My Best Begards



Edited 1 time(s). Last edit at 03/12/2012 11:29AM by Mohammad Qamar.

Options: ReplyQuote


Subject Written By Posted
problem for selecting range of date between 2 dates Mohammad Qamar 03/12/2012 06:35AM
Re: problem for selecting range of date between 2 dates Grzegorz Agacinski 03/13/2012 06:41AM
Re: problem for selecting range of date between 2 dates Mohammad Qamar 03/13/2012 03:01PM
Re: problem for selecting range of date between 2 dates irek kordirko 03/13/2012 04:10PM
Re: problem for selecting range of date between 2 dates Rick James 03/22/2012 07:59PM
Re: problem for selecting range of date between 2 dates Peter Brawley 03/13/2012 03:40PM


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.