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!

How to calculate date from sysdate

User_6Q8J8Sep 12 2013 — edited Sep 12 2013

I am trying to get 9/12/2009 12:51:30 PM by subtracting the current date from sysdate.

I can get the year with this but I am not sure how i can arrive to the above date and month.

( select add_months(sysdate,-36) from dual) = 9/12/2010

expected result 9/12/2010 01:23:30 PM

thank you for the help

This post has been answered by Warren Tolentino on Sep 12 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2013

Added on Sep 12 2013

5 comments

1,409 views