http://www.sqlzoo.net/w/index.php?title=QUARTER&feed=atom&action=history QUARTER - Revision history 2013-06-18T06:46:59Z Revision history for this page on the wiki MediaWiki 1.20.4 http://www.sqlzoo.net/w/index.php?title=QUARTER&diff=4245&oldid=prev Peter at 21:25, 21 October 2012 2012-10-21T21:25:50Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 21:25, 21 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 69:</td> <td colspan="2" class="diff-lineno">Line 69:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[MONTH |MONTH function]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[MONTH |MONTH function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Languages}}</ins></div></td></tr> </table> Peter http://www.sqlzoo.net/w/index.php?title=QUARTER&diff=1390&oldid=prev Connor at 15:19, 16 July 2012 2012-07-16T15:19:37Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 15:19, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 5:</td> <td colspan="2" class="diff-lineno">Line 5:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;mysql&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;mysql&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[TO_CHAR(d,'Q')]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">TO_CHAR(dates) |</ins>TO_CHAR(d,'Q')]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[DATEPART |DATEPART(QUARTER,d)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[DATEPART |DATEPART(QUARTER,d)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 37:</td> <td colspan="2" class="diff-lineno">Line 37:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; TO_CHAR(wk,'QUARTER') AS Quarter,</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; TO_CHAR(wk,'QUARTER') AS Quarter,</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; song</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; song</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; FROM totp</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; FROM <ins class="diffchange diffchange-inline">gisq.</ins>totp</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; WHERE singer = 'Cliff Richard'</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; WHERE singer = 'Cliff Richard'</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; ORDER BY wk DESC</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; ORDER BY wk DESC</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 62:</td> <td colspan="2" class="diff-lineno">Line 62:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;ul&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;ul&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[EXTRACT |EXTRACT function]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[EXTRACT |EXTRACT function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[ +(date) function]]&lt;/li&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[<ins class="diffchange diffchange-inline">%2B(dates) |</ins>+(date) function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[HOUR |HOUR function]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[HOUR |HOUR function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[MINUTE |MINUTE function]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[MINUTE |MINUTE function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[DAY |DAY function]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[DAY |DAY function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[SECOND function]]&lt;/li&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[<ins class="diffchange diffchange-inline">SECOND |</ins>SECOND function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[MONTH |MONTH function]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[MONTH |MONTH function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td></tr> </table> Connor http://www.sqlzoo.net/w/index.php?title=QUARTER&diff=1307&oldid=prev Connor at 11:56, 16 July 2012 2012-07-16T11:56:20Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 11:56, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 17:</td> <td colspan="2" class="diff-lineno">Line 17:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;Second Quarter&lt;/td&gt;&lt;td align='left'&gt;April 1&lt;/td&gt;&lt;td&gt;June 30&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;Second Quarter&lt;/td&gt;&lt;td align='left'&gt;April 1&lt;/td&gt;&lt;td&gt;June 30&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;Third Quarter&lt;/td&gt;&lt;td align='left'&gt;July 1&lt;/td&gt;&lt;td&gt;September 30&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;Third Quarter&lt;/td&gt;&lt;td align='left'&gt;July 1&lt;/td&gt;&lt;td&gt;September 30&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;Fourth Quarter&lt;/td&gt;&lt;td align='left'&gt;October 1&lt;/td&gt;December 31&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;Fourth Quarter&lt;/td&gt;&lt;td align='left'&gt;October 1&lt;/<ins class="diffchange diffchange-inline">td&gt;&lt;</ins>td&gt;December 31&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;pre style='width:60ex'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;pre style='width:60ex'&gt;</div></td></tr> </table> Connor http://www.sqlzoo.net/w/index.php?title=QUARTER&diff=1306&oldid=prev Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>QUARTER(d)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''<..." 2012-07-16T11:54:25Z <p>Created page with &quot;&lt;table align=&#039;right&#039; border=&#039;1&#039;&gt; &lt;caption&gt;Compatibility&lt;/caption&gt; &lt;tr&gt;&lt;th colspan=&#039;3&#039;&gt;QUARTER(d)&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td align=&#039;center&#039;&gt;&#039;&#039;&#039;Engine&#039;&#039;&#039;&lt;/td&gt;&lt;td align=&#039;center&#039;&gt;&#039;&#039;&#039;OK&#039;&#039;&#039;&lt;...&quot;</p> <p><b>New page</b></p><div>&lt;table align='right' border='1'&gt;<br /> &lt;caption&gt;Compatibility&lt;/caption&gt;<br /> &lt;tr&gt;&lt;th colspan='3'&gt;QUARTER(d)&lt;/th&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;mysql&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[TO_CHAR(d,'Q')]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(QUARTER from d)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[DATEPART |DATEPART(QUARTER,d)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;/table&gt;<br /> &lt;h1&gt;QUARTER&lt;/h1&gt;<br /> &lt;p&gt;QUARTER allows you to retrieve the 3 month period from a date.&lt;/p&gt;<br /> &lt;table class='NoBorder'&gt;<br /> &lt;caption&gt;QUARTERS&lt;/caption&gt;<br /> &lt;tr&gt;&lt;th&gt;&lt;/th&gt;&lt;th&gt;&lt;/th&gt;&lt;th&gt;&lt;/th&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;First Quarter&lt;/td&gt;&lt;td align='left'&gt;January 1&lt;/td&gt;&lt;td&gt;March 31&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;Second Quarter&lt;/td&gt;&lt;td align='left'&gt;April 1&lt;/td&gt;&lt;td&gt;June 30&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;Third Quarter&lt;/td&gt;&lt;td align='left'&gt;July 1&lt;/td&gt;&lt;td&gt;September 30&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;Fourth Quarter&lt;/td&gt;&lt;td align='left'&gt;October 1&lt;/td&gt;December 31&lt;/td&gt;&lt;/tr&gt;<br /> &lt;/table&gt;<br /> &lt;pre style='width:60ex'&gt;<br /> QUARTER(d)<br /> &lt;/pre&gt;<br /> <br /> &lt;div class='ht'&gt;<br /> In this example you get the quarter from the date field wk. Lately, Cliff Richard favours Q4. <br /> &lt;source lang='sql' class='def e-postgres'&gt;<br /> SELECT wk,<br /> EXTRACT(QUARTER from wk) AS Quarter,<br /> song<br /> FROM totp<br /> WHERE singer = 'Cliff Richard'<br /> ORDER BY wk DESC<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def e-oracle'&gt;<br /> SELECT wk,<br /> TO_CHAR(wk,'QUARTER') AS Quarter,<br /> song<br /> FROM totp<br /> WHERE singer = 'Cliff Richard'<br /> ORDER BY wk DESC<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def e-sqlserver'&gt;<br /> SELECT wk,<br /> DATEPART(QUARTER,wk) AS Quarter,<br /> song<br /> FROM totp<br /> WHERE singer = 'Cliff Richard'<br /> ORDER BY wk DESC<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def'&gt;<br /> SELECT wk,<br /> QUARTER(wk) AS Quarter,<br /> song<br /> FROM totp<br /> WHERE singer = 'Cliff Richard'<br /> ORDER BY wk DESC<br /> &lt;/source&gt;<br /> &lt;/div&gt;<br /> <br /> &lt;p&gt;See also&lt;/p&gt;<br /> &lt;ul&gt;<br /> &lt;li&gt;[[EXTRACT |EXTRACT function]]&lt;/li&gt;<br /> &lt;li&gt;[[ +(date) function]]&lt;/li&gt;<br /> &lt;li&gt;[[HOUR |HOUR function]]&lt;/li&gt;<br /> &lt;li&gt;[[MINUTE |MINUTE function]]&lt;/li&gt;<br /> &lt;li&gt;[[DAY |DAY function]]&lt;/li&gt;<br /> &lt;li&gt;[[SECOND function]]&lt;/li&gt;<br /> &lt;li&gt;[[MONTH |MONTH function]]&lt;/li&gt;<br /> &lt;/ul&gt;</div> Connor