Difference between revisions of "DATEPART"
From SQLZOO
| Line 3: | Line 3: | ||
<tr><th colspan='3'>DATEPART(YEAR, d)</th></tr> | <tr><th colspan='3'>DATEPART(YEAR, 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>No</td><td>[[EXTRACT| | + | <tr><td align='left'>ingres</td><td>No</td><td>[[EXTRACT|EXTRACT(YEAR FROM d)]]</td></tr> |
| − | <tr><td align='left'>mysql</td><td>No</td><td>[ | + | <tr><td align='left'>mysql</td><td>No</td><td>[[EXTACT|EXTRACT(YEAR FROM d)]]</td></tr> |
| − | <tr><td align='left'>oracle</td><td>No</td><td>[ | + | <tr><td align='left'>oracle</td><td>No</td><td>[[EXTACT|EXTRACT(YEAR FROM d)]]</td></tr> |
| − | <tr><td align='left'>postgres</td><td>No</td><td>[ | + | <tr><td align='left'>postgres</td><td>No</td><td>[[EXTRACT|EXTRACT(YEAR FROM d)]]</td></tr> |
<tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr> | <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr> | ||
</table> | </table> | ||
Revision as of 11:18, 13 July 2012
| DATEPART(YEAR, d) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | No | EXTRACT(YEAR FROM d) |
| mysql | No | EXTRACT(YEAR FROM d) |
| oracle | No | EXTRACT(YEAR FROM d) |
| postgres | No | EXTRACT(YEAR FROM d) |
| sqlserver | Yes | |
DATEPART
DATEPART allows you to retrieve components of a date.
You can extract also YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.
DATEPART(YEAR, d) DATEPART(MONTH, d) DATEPART(DAY, d) DATEPART(HOUR, d) DATEPART(MINUTE, d) DATEPART(SECOND, d)
In this example you get the year and the month from the date whn.
SELECT whn ,DATEPART(YEAR, whn) AS yr ,DATEPART(MONTH, whn) AS mnth FROM eclipse
SELECT whn ,EXTRACT(YEAR FROM td) AS yr ,EXTRACT(MONTH FROM td) AS mnth FROM eclipse
See also
