http://sqlzoo.net/w/index.php?title=EXTRACT&feed=atom&action=history
EXTRACT - Revision history
2013-05-23T18:38:07Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=EXTRACT&diff=4231&oldid=prev
Peter at 20:55, 21 October 2012
2012-10-21T20:55:08Z
<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 20:55, 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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>[[DATEPART |DATEPART(YEAR, d)]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>[[DATEPART |DATEPART(YEAR, d)]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr>
<tr><td colspan="2"> </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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>EXTRACT</h1></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>EXTRACT</h1></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>EXTRACT allows you to retrieve components of a date.</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>EXTRACT allows you to retrieve components of a date.</p></div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 42:</td>
<td colspan="2" class="diff-lineno">Line 43:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[%2B(dates) |+ date]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[%2B(dates) |+ date]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
<tr><td colspan="2"> </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"> </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://sqlzoo.net/w/index.php?title=EXTRACT&diff=1368&oldid=prev
Connor at 14:56, 16 July 2012
2012-07-16T14:56:03Z
<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:56, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 26:</td>
<td colspan="2" class="diff-lineno">Line 26:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source>  </div></td></tr>
<tr><td colspan="2"> </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;"><source lang ='sql' class='def e-oracle'>SELECT whn</ins></div></td></tr>
<tr><td colspan="2"> </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;">      ,EXTRACT(YEAR FROM td)  AS yr</ins></div></td></tr>
<tr><td colspan="2"> </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;">      ,EXTRACT(HOUR FROM td) AS hr</ins></div></td></tr>
<tr><td colspan="2"> </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;">  FROM gisq.eclipse  </ins></div></td></tr>
<tr><td colspan="2"> </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;"></source></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang ='sql' class='def'>SELECT whn</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang ='sql' class='def'>SELECT whn</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,EXTRACT(YEAR FROM td)  AS yr</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,EXTRACT(YEAR FROM td)  AS yr</div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=EXTRACT&diff=1367&oldid=prev
Connor at 14:55, 16 July 2012
2012-07-16T14:55:28Z
<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:55, 16 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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[YEAR(d)]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[<ins class="diffchange diffchange-inline">YEAR |</ins>YEAR(d)]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>Yes</td><td>[[TO_CHAR(d,'YYYY')]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>Yes</td><td>[[<ins class="diffchange diffchange-inline">TO_CHAR(dates) |</ins>TO_CHAR(d,'YYYY')]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>Yes</td><td>[[YEAR(d)]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>Yes</td><td>[[<ins class="diffchange diffchange-inline">YEAR |</ins>YEAR(d)]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>[[DATEPART |DATEPART(YEAR, d)]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>[[DATEPART |DATEPART(YEAR, d)]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 35:</td>
<td colspan="2" class="diff-lineno">Line 35:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[+ date]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">%2B(dates) |</ins>+ date]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=EXTRACT&diff=1185&oldid=prev
Connor at 11:34, 13 July 2012
2012-07-13T11:34:44Z
<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:34, 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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>Yes</td><td>[[TO_CHAR(d,'YYYY')]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>Yes</td><td>[[TO_CHAR(d,'YYYY')]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>Yes</td><td>[[YEAR(d)]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>Yes</td><td>[[YEAR(d)]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>[<del class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/</del>DATEPART DATEPART(YEAR, d)]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>[<ins class="diffchange diffchange-inline">[</ins>DATEPART <ins class="diffchange diffchange-inline">|</ins>DATEPART(YEAR, d)<ins class="diffchange diffchange-inline">]</ins>]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>EXTRACT</h1></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>EXTRACT</h1></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=EXTRACT&diff=1178&oldid=prev
Connor at 11:12, 13 July 2012
2012-07-13T11:12: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:12, 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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th colspan='3'>EXTRACT(YEAR FROM d)</th></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th colspan='3'>EXTRACT(YEAR FROM d)</th></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td><del class="diffchange diffchange-inline">[[EXTRACT(YEAR FROM d)]]</del></td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[YEAR(d)]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[YEAR(d)]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>Yes</td><td>[[TO_CHAR(d,'YYYY')]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>Yes</td><td>[[TO_CHAR(d,'YYYY')]]</td></tr></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=EXTRACT&diff=1177&oldid=prev
Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>EXTRACT(YEAR FROM d)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'..."
2012-07-13T11:11:52Z
<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>EXTRACT(YEAR FROM d)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'..."</p>
<p><b>New page</b></p><div><table align='right' border='1'><br />
<caption>Compatibility</caption><br />
<tr><th colspan='3'>EXTRACT(YEAR FROM d)</th></tr><br />
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br />
<tr><td align='left'>ingres</td><td>Yes</td><td>[[EXTRACT(YEAR FROM d)]]</td></tr><br />
<tr><td align='left'>mysql</td><td>Yes</td><td>[[YEAR(d)]]</td></tr><br />
<tr><td align='left'>oracle</td><td>Yes</td><td>[[TO_CHAR(d,'YYYY')]]</td></tr><br />
<tr><td align='left'>postgres</td><td>Yes</td><td>[[YEAR(d)]]</td></tr><br />
<tr><td align='left'>sqlserver</td><td>No</td><td>[http://sqlzoo.net/w/index.php/DATEPART DATEPART(YEAR, d)]</td></tr><br />
</table><br />
<h1>EXTRACT</h1><br />
<p>EXTRACT allows you to retrieve components of a date.</p><br />
<p>You can extract also YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.</p> <br />
<pre style='width:70ex'><br />
EXTRACT(YEAR FROM d) EXTRACT(MONTH FROM d)<br />
EXTRACT(DAY FROM d) EXTRACT(HOUR FROM d)<br />
EXTRACT(MINUTE FROM d) EXTRACT(SECOND FROM d)<br />
</pre><br />
<br />
<div class='ht'><br />
In this example you get the year and the hour from the date <code>whn</code>.<br />
<source lang='sql' class='def e-sqlserver'><br />
SELECT whn<br />
,DATEPART(YEAR, whn) AS yr<br />
,DATEPART(HOUR, whn) AS hr<br />
FROM eclipse<br />
</source> <br />
<source lang ='sql' class='def'>SELECT whn<br />
,EXTRACT(YEAR FROM td) AS yr<br />
,EXTRACT(HOUR FROM td) AS hr<br />
FROM eclipse <br />
</source><br />
</div><br />
<br />
<p>See also</p><br />
<ul><br />
<li>[[+ date]]</li><br />
</ul></div>
Connor