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!

Sysdate minus 6 months

User_OGFJBNov 29 2018 — edited Nov 29 2018

Need sql query to get 6 months back date.

E.g. If today is 31-Oct-2018 then sql query should result 1-May-2018.

Comments
Post Details
Added on Nov 29 2018
8 comments
26,704 views