Difference between revisions of "YEAR"
From SQLZOO
(Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>YEAR(d)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td...") |
|||
| Line 28: | Line 28: | ||
,whn | ,whn | ||
,wht | ,wht | ||
| − | FROM eclipse | + | FROM gisq.eclipse |
</source> | </source> | ||
<source lang='sql' class='def'> | <source lang='sql' class='def'> | ||
Revision as of 13:11, 16 July 2012
| YEAR(d) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | EXTRACT(YEAR from d) |
| mysql | Yes | EXTRACT(YEAR from d) |
| oracle | No | TO_CHAR(d,'YYYY') |
| postgres | No | EXTRACT(YEAR from d) |
| sqlserver | Yes | DATEPART(YEAR,d) |
YEAR
YEAR allows you to retrieve the year from a date.
YEAR(d)
In this example you get the year from the date field whn.
SELECT EXTRACT(YEAR FROM whn) AS v ,whn ,wht FROM eclipse
SELECT TO_CHAR(whn,'YEAR') AS v ,whn ,wht FROM gisq.eclipse
SELECT YEAR(whn) AS v, whn, wht FROM eclipse
See also
