By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,504 Members | 1,170 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,504 IT Pros & Developers. It's quick & easy.

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

P: 5
to_date(expiration_dt,('DD-MON-YY')) < to_date(add_months(sysdate,#MONTHS 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
Dec 4 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.