Difference between revisions of "SECOND"
From SQLZOO
(Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>SECOND(d)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</...") |
|||
| Line 3: | Line 3: | ||
<tr><th colspan='3'>SECOND(d)</th></tr> | <tr><th colspan='3'>SECOND(d)</th></tr> | ||
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr> | <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr> | ||
| − | <tr><td align='left'>ingres</td><td>Yes</td><td>[[EXTRACT |EXTRACT( | + | <tr><td align='left'>ingres</td><td>Yes</td><td>[[EXTRACT |EXTRACT(SECOND from d)]]</td></tr> |
| − | <tr><td align='left'>mysql</td><td>Yes</td><td>[[EXTRACT |EXTRACT( | + | <tr><td align='left'>mysql</td><td>Yes</td><td>[[EXTRACT |EXTRACT(SECOND from d)]]</td></tr> |
<tr><td align='left'>oracle</td><td>No</td><td>[[TO_CHAR(d,'HH24')]]</td></tr> | <tr><td align='left'>oracle</td><td>No</td><td>[[TO_CHAR(d,'HH24')]]</td></tr> | ||
| − | <tr><td align='left'>postgres</td><td>No</td><td>[[EXTRACT |EXTRACT( | + | <tr><td align='left'>postgres</td><td>No</td><td>[[EXTRACT |EXTRACT(SECOND from d)]]</td></tr> |
| − | <tr><td align='left'>sqlserver</td><td>Yes</td><td>[[DATEPART |DATEPART( | + | <tr><td align='left'>sqlserver</td><td>Yes</td><td>[[DATEPART |DATEPART(SECOND,d)]]</td></tr> |
</table> | </table> | ||
<h1>SECOND</h1> | <h1>SECOND</h1> | ||
| Line 13: | Line 13: | ||
<p></p> | <p></p> | ||
<pre style='width:60ex'> | <pre style='width:60ex'> | ||
| − | + | SECOND(d) | |
</pre> | </pre> | ||
Revision as of 13:57, 16 July 2012
| SECOND(d) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | EXTRACT(SECOND from d) |
| mysql | Yes | EXTRACT(SECOND from d) |
| oracle | No | TO_CHAR(d,'HH24') |
| postgres | No | EXTRACT(SECOND from d) |
| sqlserver | Yes | DATEPART(SECOND,d) |
SECOND
SECOND allows you to retrieve the second from a date.
SECOND(d)
In this example you get the second from the date field whn.
SELECT EXTRACT(SECOND FROM whn) AS v ,whn ,wht FROM eclipse
SELECT TO_CHAR(whn,'SECOND') AS v ,whn ,wht FROM gisq.eclipse
SELECT SECOND(whn) AS v, whn, wht FROM eclipse
See also
