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