-
add_months
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|