Difference between revisions of "MONTH"
From SQLZOO
| (4 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
<tr><th colspan='3'>MONTH(d)</th></tr> | <tr><th colspan='3'>MONTH(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(MONTH 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(MONTH from d)]]</td></tr> |
| − | <tr><td align='left'>oracle</td><td>No</td><td>[[TO_CHAR(d,' | + | <tr><td align='left'>oracle</td><td>No</td><td>[[TO_CHAR(dates) |TO_CHAR(d,'MM')]]</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(MONTH 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(MONTH,d)]]</td></tr> |
</table> | </table> | ||
| − | <h1> | + | <h1>MONTH</h1> |
| − | <p> | + | <p>MONTH allows you to retrieve the month from a date.</p> |
<p></p> | <p></p> | ||
<pre style='width:60ex'> | <pre style='width:60ex'> | ||
| − | + | MONTH(d) | |
</pre> | </pre> | ||
<div class='ht'> | <div class='ht'> | ||
| − | In this example you get the | + | In this example you get the month from the date field whn. |
<source lang='sql' class='def e-postgres'> | <source lang='sql' class='def e-postgres'> | ||
SELECT EXTRACT(MONTH from whn) AS v | SELECT EXTRACT(MONTH from whn) AS v | ||
| Line 39: | Line 39: | ||
<ul> | <ul> | ||
<li>[[EXTRACT |EXTRACT function]]</li> | <li>[[EXTRACT |EXTRACT function]]</li> | ||
| − | <li>[[ +(date) function]]</li> | + | <li>[[%2B(dates) |+(date) function]]</li> |
<li>[[HOUR |HOUR function]]</li> | <li>[[HOUR |HOUR 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> | ||
| + | |||
| + | {{Languages}} | ||
Latest revision as of 21:24, 21 October 2012
| MONTH(d) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | EXTRACT(MONTH from d) |
| mysql | Yes | EXTRACT(MONTH from d) |
| oracle | No | TO_CHAR(d,'MM') |
| postgres | No | EXTRACT(MONTH from d) |
| sqlserver | Yes | DATEPART(MONTH,d) |
MONTH
MONTH allows you to retrieve the month from a date.
MONTH(d)
In this example you get the month from the date field whn.
SELECT EXTRACT(MONTH FROM whn) AS v ,whn ,wht FROM eclipse
SELECT TO_CHAR(whn,'MONTH') AS v ,whn ,wht FROM gisq.eclipse
SELECT MONTH(whn) AS v, whn, wht FROM eclipse
See also
| Language: | English • Deutsch |
|---|
