Latest revision as of 18:02, 21 October 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 gisq.eclipse

SELECT DAY(whn) AS v
      ,whn
      ,wht
  FROM eclipse

@@ Line 9: / Line 9: @@
 <tr><td align='left'>sqlserver</td><td>Yes</td><td>[[DATEPART |DATEPART(DAY,d)]]</td></tr>
 </table>
 <h1>DAY</h1>
 <p>DAY allows you to retrieve the day from a date.</p>
@@ Line 53: / Line 54: @@
    <li>[[SECOND |SECOND function]]</li>
 </ul>
+{{Languages}}