Revision as of 15:19, 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 gisq.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 5: / Line 5: @@
 <tr><td align='left'>ingres</td><td>Yes</td><td>[[EXTRACT |EXTRACT(QUARTER from d)]]</td></tr>
 <tr><td align='left'>mysql</td><td>Yes</td><td>[[EXTRACT |EXTRACT(QUARTER from d)]]</td></tr>
-<tr><td align='left'>oracle</td><td>No</td><td>[[TO_CHAR(d,'Q')]]</td></tr>
+<tr><td align='left'>oracle</td><td>No</td><td>[[TO_CHAR(dates) |TO_CHAR(d,'Q')]]</td></tr>
 <tr><td align='left'>postgres</td><td>No</td><td>[[EXTRACT |EXTRACT(QUARTER from d)]]</td></tr>
 <tr><td align='left'>sqlserver</td><td>No</td><td>[[DATEPART |DATEPART(QUARTER,d)]]</td></tr>
@@ Line 37: / Line 37: @@
         TO_CHAR(wk,'QUARTER') AS Quarter,
         song
-   FROM totp
+   FROM gisq.totp
   WHERE singer = 'Cliff Richard'
   ORDER BY wk DESC
@@ Line 62: / Line 62: @@
 <ul>
    <li>[[EXTRACT |EXTRACT function]]</li>
-   <li>[[ +(date) function]]</li>
+   <li>[[%2B(dates) |+(date) function]]</li>
    <li>[[HOUR |HOUR function]]</li>
    <li>[[MINUTE |MINUTE function]]</li>
    <li>[[DAY |DAY function]]</li>
-   <li>[[SECOND function]]</li>
+   <li>[[SECOND |SECOND function]]</li>
    <li>[[MONTH |MONTH function]]</li>
 </ul>