i'm unable to fetch dates, details are as follows:-

Input parameter is - dd/mm/yyyy

Table data - Column Month and Year.

Current query is

select * from table_name tn where
(tn.month > '10' and tn.year = '2009') or
(tn.year = '2009' and tn.month <'12'))

// problem is that this will fetch duplicate records as months <'12' will also return duplicate data.

How to implement between here in columns where months and year are seperate.

Please advise.