Hi,

I have requirement to check one month back of sysdate to see if hiredate is less then the sysdate. In this where clause I have to use format MON-YYYY on both side client does not want to check with DD-MON-YYYY. How I can check this only month & year? Please see below e.g


where to_char(trunc(hire_date),'MON-YYYY') < add_months(trunc(sysdate),-1)

* The left side of the condition is fine, but don't know how to use MON-YYYY on the right side.

Thanks in advance.