http://www.sqlzoo.net/w/index.php?title=DATEPART&feed=atom&action=history 2013-05-22T18:29:52Z Revision history for this page on the wiki MediaWiki 1.20.4 http://www.sqlzoo.net/w/index.php?title=DATEPART&diff=4224&oldid=prev 2012-10-21T17:51:58Z

<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 17:51, 21 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 9:</td> <td colspan="2" class="diff-lineno">Line 9:</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;Yes&lt;/td&gt;&lt;td&gt;DATEPART(YEAR, 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;Yes&lt;/td&gt;&lt;td&gt;DATEPART(YEAR, 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;/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 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 class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;DATEPART&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;DATEPART&lt;/h1&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;DATEPART allows you to retrieve components of a date.&lt;/p&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;DATEPART allows you to retrieve components of a date.&lt;/p&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 43:</td> <td colspan="2" class="diff-lineno">Line 44:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[%2B(dates) |+ date]]&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;[[%2B(dates) |+ date]]&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=DATEPART&diff=1362&oldid=prev 2012-07-16T14:50:31Z

<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 14:50, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 27:</td> <td colspan="2" class="diff-lineno">Line 27:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; FROM eclipse</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; FROM eclipse</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt; &#160;</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;">&lt;source lang ='sql' class='def e-oracle'&gt;SELECT whn</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;">&#160; &#160; &#160; ,EXTRACT(YEAR FROM td)&#160; AS yr</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;">&#160; &#160; &#160; ,EXTRACT(MONTH FROM td) AS mnth</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;">&#160; FROM gisq.eclipse&#160; </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;">&lt;/source&gt;</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang ='sql' class='def'&gt;SELECT whn</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang ='sql' class='def'&gt;SELECT whn</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; ,EXTRACT(YEAR FROM td)&#160; AS yr</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; ,EXTRACT(YEAR FROM td)&#160; AS yr</div></td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=DATEPART&diff=1361&oldid=prev 2012-07-16T14:49:54Z

<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 14:49, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 36:</td> <td colspan="2" class="diff-lineno">Line 36:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;See also&lt;/p&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;See also&lt;/p&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 class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[%2B(<del class="diffchange diffchange-inline">date</del>) |+ date]]&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;[[%2B(<ins class="diffchange diffchange-inline">dates</ins>) |+ date]]&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=DATEPART&diff=1360&oldid=prev 2012-07-16T14:49:26Z

<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 14:49, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 36:</td> <td colspan="2" class="diff-lineno">Line 36:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;See also&lt;/p&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;See also&lt;/p&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 class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[+ date]]&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(date) |</ins>+ date]]&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=DATEPART&diff=1184&oldid=prev 2012-07-13T11:33:30Z

<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:33, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 7:</td> <td colspan="2" class="diff-lineno">Line 7:</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;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT|EXTRACT(YEAR 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;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT|EXTRACT(YEAR 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;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT|EXTRACT(YEAR 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(YEAR 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;sqlserver&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;&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;sqlserver&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;<ins class="diffchange diffchange-inline">DATEPART(YEAR, d)</ins>&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;h1&gt;DATEPART&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;DATEPART&lt;/h1&gt;</div></td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=DATEPART&diff=1183&oldid=prev 2012-07-13T11:28:14Z

<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:28, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 19:</td> <td colspan="2" class="diff-lineno">Line 19:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class='ht'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class='ht'&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;">&lt;div class=params&gt;schema:gisq&lt;/div&gt;</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example you get the year and the month from the date &lt;code&gt;whn&lt;/code&gt;.</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example you get the year and the month from the date &lt;code&gt;whn&lt;/code&gt;.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-sqlserver'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-sqlserver'&gt;</div></td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=DATEPART&diff=1182&oldid=prev 2012-07-13T11:19:10Z

<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:19, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 4:</td> <td colspan="2" class="diff-lineno">Line 4:</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='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;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&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;</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;ingres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT|EXTRACT(YEAR 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;No&lt;/td&gt;&lt;td&gt;[[EXTRACT|EXTRACT(YEAR 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;mysql&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<del class="diffchange diffchange-inline">EXTACT</del>|EXTRACT(YEAR FROM d)]]&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;mysql&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">EXTRACT</ins>|EXTRACT(YEAR 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;[[<del class="diffchange diffchange-inline">EXTACT</del>|EXTRACT(YEAR FROM d)]]&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">EXTRACT</ins>|EXTRACT(YEAR 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;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT|EXTRACT(YEAR 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(YEAR 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;Yes&lt;/td&gt;&lt;td&gt;&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;Yes&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;</div></td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=DATEPART&diff=1181&oldid=prev 2012-07-13T11:18:53Z

<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:18, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 3:</td> <td colspan="2" class="diff-lineno">Line 3:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;th colspan='3'&gt;DATEPART(YEAR, d)&lt;/th&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;th colspan='3'&gt;DATEPART(YEAR, d)&lt;/th&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='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;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&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;</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;ingres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT|<del class="diffchange diffchange-inline">EXTRACT </del>EXTRACT(YEAR FROM d)]]&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;ingres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT|EXTRACT(YEAR 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;mysql&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[<del class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/EXTRACT </del>EXTRACT(YEAR FROM d)]&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;mysql&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[<ins class="diffchange diffchange-inline">[EXTACT|</ins>EXTRACT(YEAR FROM d)<ins class="diffchange diffchange-inline">]</ins>]&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;[<del class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/EXTRACT </del>EXTRACT(YEAR FROM d]<del class="diffchange diffchange-inline">)</del>&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">[EXTACT|</ins>EXTRACT(YEAR FROM d<ins class="diffchange diffchange-inline">)]</ins>]&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;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[<del class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/</del>EXTRACT EXTRACT(YEAR FROM d)]&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;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[<ins class="diffchange diffchange-inline">[</ins>EXTRACT<ins class="diffchange diffchange-inline">|</ins>EXTRACT(YEAR FROM d)<ins class="diffchange diffchange-inline">]</ins>]&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;Yes&lt;/td&gt;&lt;td&gt;&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;Yes&lt;/td&gt;&lt;td&gt;&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> </table>

Connor http://www.sqlzoo.net/w/index.php?title=DATEPART&diff=1180&oldid=prev 2012-07-13T11:17:39Z

<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:17, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 3:</td> <td colspan="2" class="diff-lineno">Line 3:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;th colspan='3'&gt;DATEPART(YEAR, d)&lt;/th&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;th colspan='3'&gt;DATEPART(YEAR, d)&lt;/th&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='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;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&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;</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;ingres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT EXTRACT(YEAR FROM d)]]&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;ingres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">EXTRACT|</ins>EXTRACT EXTRACT(YEAR 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;No&lt;/td&gt;&lt;td&gt;[http://sqlzoo.net/w/index.php/EXTRACT EXTRACT(YEAR 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;No&lt;/td&gt;&lt;td&gt;[http://sqlzoo.net/w/index.php/EXTRACT EXTRACT(YEAR 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;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[http://sqlzoo.net/w/index.php/EXTRACT EXTRACT(YEAR 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;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[http://sqlzoo.net/w/index.php/EXTRACT EXTRACT(YEAR FROM d])&lt;/td&gt;&lt;/tr&gt;</div></td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=DATEPART&diff=1179&oldid=prev 2012-07-13T11:13:32Z

<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:13, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 3:</td> <td colspan="2" class="diff-lineno">Line 3:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;th colspan='3'&gt;DATEPART(YEAR, d)&lt;/th&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;th colspan='3'&gt;DATEPART(YEAR, d)&lt;/th&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='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;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&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;</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;ingres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT(YEAR FROM d)]]&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;ingres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[<ins class="diffchange diffchange-inline">EXTRACT </ins>EXTRACT(YEAR 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;mysql&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[<del class="diffchange diffchange-inline">[</del>EXTRACT(YEAR FROM d)<del class="diffchange diffchange-inline">]</del>]&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;mysql&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[<ins class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/EXTRACT </ins>EXTRACT(YEAR 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;[<del class="diffchange diffchange-inline">[</del>EXTRACT(YEAR FROM d<del class="diffchange diffchange-inline">]</del>])&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">http://sqlzoo.net/w/index.php/EXTRACT </ins>EXTRACT(YEAR 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;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[<del class="diffchange diffchange-inline">[</del>EXTRACT(YEAR FROM d)<del class="diffchange diffchange-inline">]</del>]&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;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[<ins class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/EXTRACT </ins>EXTRACT(YEAR 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;Yes&lt;/td&gt;&lt;td&gt;&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;Yes&lt;/td&gt;&lt;td&gt;&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> </table>

Connor