Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

match date and month with another date

User_FZ3ZWMar 26 2015 — edited Mar 26 2015

HI,

I want to match customer date of birth date and month with policy expiry date+ 30 days.   for e.g. if customer date of birth is 14-sep-1965

and policy taken on 07-sep-1984 and expiry date is 07-sep-1985.  i want to match whether customer date of birth date and month(14-sep) lies between 07-sep and 07-oct.

how can i do that.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2015
Added on Mar 26 2015
8 comments
1,340 views