Skip to Main Content
Forums

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!

PL / SQL Date Add at Quarter Intervals

996929Mar 14 2013 — edited Mar 14 2013
I am looking to select a date in 'DD-MON-YYYY' format, convert this to 'Q-YYYY' format and add or subtract at the interval of Quarter. E.g. trunc(sysdate,'Q-YYYY') -1 would return 4-2012.

This appears to be possible whilst using other intervals e.g.

trunc(sysdate,'iw') -7 returns 04-MAR-13 without error.

Please advise if possible.

Thanks in advance,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2013
Added on Mar 14 2013
#general-database-discussions, #plsql, #query
3 comments
13,040 views