Latest revision as of 17:51, 21 October 2012

DATEPART

DATEPART allows you to retrieve components of a date.

You can extract also YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.

   DATEPART(YEAR, d)    DATEPART(MONTH, d)
   DATEPART(DAY, d)     DATEPART(HOUR, d)
   DATEPART(MINUTE, d)  DATEPART(SECOND, d)

schema:gisq

In this example you get the year and the month from the date whn.

SELECT whn
      ,DATEPART(YEAR, whn)  AS yr
      ,DATEPART(MONTH, whn) AS mnth
  FROM eclipse

SELECT whn
      ,EXTRACT(YEAR FROM td)  AS yr
      ,EXTRACT(MONTH FROM td) AS mnth
  FROM gisq.eclipse

SELECT whn
      ,EXTRACT(YEAR FROM td)  AS yr
      ,EXTRACT(MONTH FROM td) AS mnth
  FROM eclipse

@@ Line 9: / Line 9: @@
 <tr><td align='left'>sqlserver</td><td>Yes</td><td>DATEPART(YEAR, d)</td></tr>
 </table>
 <h1>DATEPART</h1>
 <p>DATEPART allows you to retrieve components of a date.</p>
@@ Line 27: / Line 28: @@
    FROM eclipse
 </source>
+<source lang ='sql' class='def e-oracle'>SELECT whn
+      ,EXTRACT(YEAR FROM td)  AS yr
+      ,EXTRACT(MONTH FROM td) AS mnth
+  FROM gisq.eclipse
+</source>
 <source lang ='sql' class='def'>SELECT whn
        ,EXTRACT(YEAR FROM td)  AS yr
@@ Line 38: / Line 44: @@
    <li>[[%2B(dates) |+ date]]</li>
 </ul>
+{{Languages}}