> For example, to get all records between 3 Feb and 18 Jun:

what about

WHERE SUBSTRING(<timestamp field> FROM 6 for 5) BETWEEN '02-03' AND '06-18'

Ivan