http://sqlzoo.net/w/index.php?title=SECOND&feed=atom&action=history 2013-06-19T02:13:16Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=SECOND&diff=4248&oldid=prev 2012-10-21T21:36:15Z

<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:36, 21 October 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(SECOND 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(SECOND 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(SECOND 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(SECOND 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(dates) |TO_CHAR(d,'<del class="diffchange diffchange-inline">HH24</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;[[TO_CHAR(dates) |TO_CHAR(d,'<ins class="diffchange diffchange-inline">SS</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;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(SECOND 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(SECOND 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;[[DATEPART |DATEPART(SECOND,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 |DATEPART(SECOND,d)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> </table>

Peter http://sqlzoo.net/w/index.php?title=SECOND&diff=4247&oldid=prev 2012-10-21T21:33:33Z

<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:33, 21 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 45:</td> <td colspan="2" class="diff-lineno">Line 45:</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://sqlzoo.net/w/index.php?title=SECOND&diff=1396&oldid=prev 2012-07-16T15:24:43Z

<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:24, 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(SECOND 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(SECOND 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(SECOND 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(SECOND 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,'HH24')]]&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,'HH24')]]&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(SECOND 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(SECOND 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;[[DATEPART |DATEPART(SECOND,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 |DATEPART(SECOND,d)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 39:</td> <td colspan="2" class="diff-lineno">Line 39:</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> </table>

Connor http://sqlzoo.net/w/index.php?title=SECOND&diff=1331&oldid=prev 2012-07-16T13:57:19Z

<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 13:57, 16 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;SECOND(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;SECOND(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;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(<del class="diffchange diffchange-inline">HOUR </del>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;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(<ins class="diffchange diffchange-inline">SECOND </ins>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;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(<del class="diffchange diffchange-inline">HOUR </del>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;Yes&lt;/td&gt;&lt;td&gt;[[EXTRACT |EXTRACT(<ins class="diffchange diffchange-inline">SECOND </ins>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;[[TO_CHAR(d,'HH24')]]&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;[[TO_CHAR(d,'HH24')]]&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;[[EXTRACT |EXTRACT(<del class="diffchange diffchange-inline">HOUR </del>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;[[EXTRACT |EXTRACT(<ins class="diffchange diffchange-inline">SECOND </ins>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;[[DATEPART |DATEPART(<del class="diffchange diffchange-inline">HOUR</del>,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;sqlserver&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[DATEPART |DATEPART(<ins class="diffchange diffchange-inline">SECOND</ins>,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 class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;SECOND&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;SECOND&lt;/h1&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 13:</td> <td colspan="2" class="diff-lineno">Line 13:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;&lt;/p&gt; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;&lt;/p&gt; &#160;</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> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; <del class="diffchange diffchange-inline">HOUR</del>(d)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; <ins class="diffchange diffchange-inline">SECOND</ins>(d)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/pre&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/pre&gt;</div></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> </table>

Connor http://sqlzoo.net/w/index.php?title=SECOND&diff=1330&oldid=prev 2012-07-16T13:53: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;SECOND(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;SECOND(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(HOUR 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(HOUR 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,'HH24')]]&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(HOUR from d)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;[[DATEPART |DATEPART(HOUR,d)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;/table&gt;<br /> &lt;h1&gt;SECOND&lt;/h1&gt;<br /> &lt;p&gt;SECOND allows you to retrieve the second from a date. &lt;/p&gt;<br /> &lt;p&gt;&lt;/p&gt; <br /> &lt;pre style='width:60ex'&gt;<br /> HOUR(d)<br /> &lt;/pre&gt;<br /> <br /> &lt;div class='ht'&gt;<br /> In this example you get the second from the date field whn. <br /> &lt;source lang='sql' class='def e-postgres'&gt;<br /> SELECT EXTRACT(SECOND from whn) AS v<br /> ,whn<br /> ,wht<br /> FROM eclipse<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def e-oracle'&gt;<br /> SELECT TO_CHAR(whn,'SECOND') AS v<br /> ,whn<br /> ,wht<br /> FROM gisq.eclipse<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def'&gt;<br /> SELECT SECOND(whn) AS v, whn, wht<br /> FROM eclipse<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;[[MONTH |MONTH function]]&lt;/li&gt;<br /> &lt;/ul&gt;</div>

Connor