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