Skip to Main Content

Oracle Database Discussions

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!

Current Year & Previous Year in two rows

451588Oct 4 2018 — edited Oct 4 2018

How to get current year and previous year data from SYSDATE in the below format

Years | Current_Year | Previous_Year  

------- | ----------------- | ------------------

2018  | 2018              | 2017

2017  | 2018              | 2017

This post has been answered by Gaz in Oz on Oct 4 2018
Jump to Answer
Comments
Post Details
Added on Oct 4 2018
5 comments
13,356 views