MySQL Forums
Forum List  »  Newbie

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




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.