title: Query to Change Quarter Timestamp Format
body: <p>I have a varchar2(2000) byte column which stores the data as- 'Q2 FY07' OR 'Q3 FY08' i need data in this format now- '2007Q2' OR '2008Q3' . Can anyone help me what should i query the sata as in oracle.</p>