Revision as of 12:56, 16 July 2012

QUARTER

QUARTER allows you to retrieve the 3 month period from a date.

   QUARTER(d)

In this example you get the quarter from the date field wk. Lately, Cliff Richard favours Q4.

SELECT wk,
       EXTRACT(QUARTER FROM wk) AS Quarter,
       song
  FROM totp
 WHERE singer = 'Cliff Richard'
 ORDER BY wk DESC

SELECT wk,
       TO_CHAR(wk,'QUARTER') AS Quarter,
       song
  FROM totp
 WHERE singer = 'Cliff Richard'
 ORDER BY wk DESC

SELECT wk,
       DATEPART(QUARTER,wk) AS Quarter,
       song
  FROM totp
 WHERE singer = 'Cliff Richard'
 ORDER BY wk DESC

SELECT wk,
       QUARTER(wk) AS Quarter,
       song
  FROM totp
 WHERE singer = 'Cliff Richard'
 ORDER BY wk DESC

@@ Line 17: / Line 17: @@
 <tr><td align='left'>Second Quarter</td><td align='left'>April 1</td><td>June 30</td></tr>
 <tr><td align='left'>Third Quarter</td><td align='left'>July 1</td><td>September 30</td></tr>
-<tr><td align='left'>Fourth Quarter</td><td align='left'>October 1</td>December 31</td></tr>
+<tr><td align='left'>Fourth Quarter</td><td align='left'>October 1</td><td>December 31</td></tr>
 </table>
 <pre style='width:60ex'>