Difference between revisions of "DAY"
From SQLZOO
| Line 47: | Line 47: | ||
<ul> | <ul> | ||
<li>[[EXTRACT |EXTRACT function]]</li> | <li>[[EXTRACT |EXTRACT function]]</li> | ||
| − | <li>[[% | + | <li>[[%2B(dates) |+(date) function]]</li> |
<li>[[MONTH |MONTH function]]</li> | <li>[[MONTH |MONTH function]]</li> | ||
<li>[[HOUR |HOUR function]]</li> | <li>[[HOUR |HOUR function]]</li> | ||
Revision as of 14:53, 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
