Difference between revisions of "HOUR"
From SQLZOO
(Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>HOUR(d)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td...") |
|||
| Line 5: | Line 5: | ||
<tr><td align='left'>ingres</td><td>No</td><td>[[EXTRACT |EXTRACT(HOUR from d)]]</td></tr> | <tr><td align='left'>ingres</td><td>No</td><td>[[EXTRACT |EXTRACT(HOUR from d)]]</td></tr> | ||
<tr><td align='left'>mysql</td><td>Yes</td><td>[[EXTRACT |EXTRACT(HOUR from d)]]</td></tr> | <tr><td align='left'>mysql</td><td>Yes</td><td>[[EXTRACT |EXTRACT(HOUR 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(dates) |TO_CHAR(d,'HH24')]]</td></tr> |
<tr><td align='left'>postgres</td><td>No</td><td>[[EXTRACT |EXTRACT(HOUR from d)]]</td></tr> | <tr><td align='left'>postgres</td><td>No</td><td>[[EXTRACT |EXTRACT(HOUR from d)]]</td></tr> | ||
<tr><td align='left'>sqlserver</td><td>Yes</td><td>[[DATEPART |DATEPART(HOUR,d)]]</td></tr> | <tr><td align='left'>sqlserver</td><td>Yes</td><td>[[DATEPART |DATEPART(HOUR,d)]]</td></tr> | ||
| Line 45: | Line 45: | ||
<ul> | <ul> | ||
<li>[[EXTRACT |EXTRACT function]]</li> | <li>[[EXTRACT |EXTRACT function]]</li> | ||
| − | <li>[[ +(date) function]]</li> | + | <li>[[%2B(dates) |+(date) function]]</li> |
| − | <li>[[MONTH function]]</li> | + | <li>[[MONTH |MONTH function]]</li> |
<li>[[MINUTE |MINUTE function]]</li> | <li>[[MINUTE |MINUTE function]]</li> | ||
<li>[[DAY |DAY function]]</li> | <li>[[DAY |DAY function]]</li> | ||
| − | <li>[[SECOND function]]</li> | + | <li>[[SECOND |SECOND function]]</li> |
</ul> | </ul> | ||
Revision as of 14:57, 16 July 2012
| HOUR(d) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | No | EXTRACT(HOUR from d) |
| mysql | Yes | EXTRACT(HOUR from d) |
| oracle | No | TO_CHAR(d,'HH24') |
| postgres | No | EXTRACT(HOUR from d) |
| sqlserver | Yes | DATEPART(HOUR,d) |
HOUR
HOUR allows you to retrieve the hour from a datetime.
HOUR(d)
In this example you get the hour from the datetime field whn.
SELECT EXTRACT(HOUR FROM whn) AS v ,whn ,wht FROM eclipse
SELECT EXTRACT(HOUR FROM whn) AS v ,whn ,wht FROM eclipse
SELECT TO_CHAR(whn,'HOUR') AS v ,whn ,wht FROM eclipse
SELECT HOUR(whn) AS v, whn, wht FROM eclipse
See also
