Skip to Main Content
Forums

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!

A Function to create dates along with Week, Quarter and Year

user13115886Sep 28 2015 — edited Sep 29 2015

Hi All,

I am trying to write a function which will create the dates automatically along with their respective Week, Quarter and Year in different columns.

For example,

Quarter     Yr/Qtr/QtrWk             Fiscal Week     Fiscal Year            Fiscal Date

4                     15-Q4-WK13                      52              2015                   9/30/2015

I would like create for one complete year for each day to display the quarter, yr/Qtr/QtrWk,  Fiscal Week , Fiscal Year Starting from 10/01/2015 to 09/30/2016.

Appreciate ur help and advice.

THankS

AMan
This post has been answered by AlbertoFaenza on Sep 28 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2015
Added on Sep 28 2015
7 comments
1,214 views