get the after 15 months which product goes expire in oracle are sql using (to_date)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ram12354
    New Member
    • Nov 2013
    • 5

    get the after 15 months which product goes expire in oracle are sql using (to_date)

    to_date(expirat ion_dt,('DD-MON-YY')) < to_date(add_mon ths(sysdate,#MO NTHS TO EXPIRIATION#),' DD-MON-YY')

    result should be march-03 -2015
    but it displaying march-03-2014 from above sysdate
    and given #months to expiration # place in 15
Working...