Hi,t

I'm trying to run a query to return values from the 10th of last month to the 9th of this month, whenever it is ran. I tried add_months but it is giving me records from a month ago e.g.

select name,dept,age
from mytable
where hire_date >= add_months(sysdate,-1)

I need the query to return value from 10th of last month to 9th of this month no matter when it is ran.

Thanks