problem for selecting range of date between 2 dates
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.
Subject
Written By
Posted
problem for selecting range of date between 2 dates
March 12, 2012 06:35AM
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.