MariaDB: EXTRACT Function
This MariaDB tutorial explains how to use the MariaDB EXTRACT function with syntax and examples.
Description
The MariaDB EXTRACT function extracts parts from a date.
Syntax
The syntax for the EXTRACT function in MariaDB is:
EXTRACT( unit FROM date )
Parameters or Arguments
- date
- A date or datetime value from which the date part is to be extracted.
- unit
The unit type of the interval such as DAY, MONTH, MINUTE, HOUR, and so on. It can be one of the following:
unit MICROSECOND SECOND MINUTE HOUR DAY WEEK MONTH QUARTER YEAR SECOND_MICROSECOND MINUTE_MICROSECOND MINUTE_SECOND HOUR_MICROSECOND HOUR_SECOND HOUR_MINUTE DAY_MICROSECOND DAY_SECOND DAY_MINUTE DAY_HOUR YEAR_MONTH
Applies To
The EXTRACT function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB EXTRACT function examples and explore how to use the EXTRACT function in MariaDB.
For example:
SELECT EXTRACT(MICROSECOND FROM '2014-05-19 08:44:21.000001'); Result: 1 SELECT EXTRACT(SECOND FROM '2014-05-19 08:44:21'); Result: 21 SELECT EXTRACT(MINUTE FROM '2014-05-19 08:44:21'); Result: 44 SELECT EXTRACT(HOUR FROM '2014-05-19 08:44:21'); Result: 8 SELECT EXTRACT(DAY FROM '2014-05-19'); Result: 19 SELECT EXTRACT(WEEK FROM '2014-05-19'); Result: 20 SELECT EXTRACT(MONTH FROM '2014-05-19'); Result: 5 SELECT EXTRACT(QUARTER FROM '2014-05-19'); Result: 2 SELECT EXTRACT(YEAR FROM '2014-05-19'); Result: 2014 SELECT EXTRACT(SECOND_MICROSECOND FROM '2014-05-19 08:44:21.000001'); Result: 21000001 SELECT EXTRACT(MINUTE_MICROSECOND FROM '2014-05-19 08:44:21.000001'); Result: 4421000001 SELECT EXTRACT(MINUTE_SECOND FROM '2014-05-19 08:44:21'); Result: 4421 SELECT EXTRACT(HOUR_MICROSECOND FROM '2014-05-19 08:44:21.000001'); Result: 84421000001 SELECT EXTRACT(HOUR_SECOND FROM '2014-05-19 08:44:21'); Result: 84421 SELECT EXTRACT(HOUR_MINUTE FROM '2014-05-19 08:44:21'); Result: 844 SELECT EXTRACT(DAY_MICROSECOND FROM '2014-05-19 08:44:21.000001'); Result: 19084421000001 SELECT EXTRACT(DAY_SECOND FROM '2014-05-19 08:44:21'); Result: 19084421 SELECT EXTRACT(DAY_MINUTE FROM '2014-05-19 08:44:21'); Result: 190844 SELECT EXTRACT(DAY_HOUR FROM '2014-05-19 08:44:21'); Result: 1908 SELECT EXTRACT(YEAR_MONTH FROM '2014-05-19'); Result: 201405
Advertisements