Revision as of 15:53, 16 July 2012

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

@@ Line 5: / Line 5: @@
 <tr><td align='left'>ingres</td><td>No</td><td>[[EXTRACT |EXTRACT(DAY from d)]]</td></tr>
 <tr><td align='left'>mysql</td><td>Yes</td><td>[[EXTRACT |EXTRACT(DAY from d)]]</td></tr>
-<tr><td align='left'>oracle</td><td>No</td><td>[[TO_CHAR |TO_CHAR(d,'DD')]]</td></tr>
+<tr><td align='left'>oracle</td><td>No</td><td>[[TO_CHAR(dates) |TO_CHAR(d,'DD')]]</td></tr>
 <tr><td align='left'>postgres</td><td>No</td><td>[[EXTRACT |EXTRACT(DAY from d)]]</td></tr>
 <tr><td align='left'>sqlserver</td><td>Yes</td><td>[[DATEPART |DATEPART(DAY,d)]]</td></tr>
@@ Line 47: / Line 47: @@
 <ul>
    <li>[[EXTRACT |EXTRACT function]]</li>
-   <li>[[%"B(dates |+(date) function]]</li>
+   <li>[[%"B(dates) |+(date) function]]</li>
    <li>[[MONTH |MONTH function]]</li>
    <li>[[HOUR |HOUR function]]</li>