query for months & quarter in date functions
840554Nov 14 2011 — edited Nov 14 2011Hi 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