SQL EXTRACT (MySQL Function)

The SQL EXTRACT() function is used to get a value (year, month, day, hour, minute, etc.) from a date/time expression. It’s supported by MySQL and Oracle, but the syntax is different. In this post we’ll discuss it’s syntax and example in MySQL.

SQL EXTRACT (MySQL Function) Syntax

EXTRACT(unit FROM date)

date is a valid date expression.
unit can be one of the following:

SQL EXTRACT (MySQL Function) Example

SELECT EXTRACT(YEAR  FROM '2010-08-07') AS StartYear, 
          EXTRACT(MONTH FROM '2010-08-07') AS StartMonth, 
          EXTRACT(DAY FROM '2010-08-07') AS StartDay 

The result will look like: