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!

query for months & quarter in date functions

840554Nov 14 2011 — edited Nov 14 2011

Hi All

Could some on assist me how to get Last Year 1st,2nd,,, months and Current Year 1st,2nd,3rd,,, months and same way Quarterly please.
I have date column Trade_date (dd/Mon/yyyy), Trade_price in Trade table
DB:Oracle 11g
Any assist would be appreciated

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2011

Added on Nov 14 2011

9 comments

2,629 views