Difference between revisions of "DATEPART"

From SQLZOO
Jump to: navigation, search
Line 36: Line 36:
 
<p>See also</p>
 
<p>See also</p>
 
<ul>
 
<ul>
   <li>[[%2B(date) |+ date]]</li>
+
   <li>[[%2B(dates) |+ date]]</li>
 
</ul>
 
</ul>

Revision as of 14:49, 16 July 2012

Compatibility
DATEPART(YEAR, d)
EngineOKAlternative
ingresNoEXTRACT(YEAR FROM d)
mysqlNoEXTRACT(YEAR FROM d)
oracleNoEXTRACT(YEAR FROM d)
postgresNoEXTRACT(YEAR FROM d)
sqlserverYesDATEPART(YEAR, d)

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 eclipse

See also

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense