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 get last quarter of the current quarter

Gor_MahiaFeb 14 2022

Hi,
iam trying to determine the last quarter value of the current quarter based on the system date(current). For instance if the current quarter is "202201" then previous quarter should be "202104", or if the current current quarter is "202103" then previous quarter should be "202102" etc.
I am using Oracle 12.x C
thanks in advance.

This post has been answered by Frank Kulash on Feb 14 2022

Jump to Answer

Added on Feb 14 2022

#plsql, #sql

9 comments

11,771 views

3 mentions