totn MariaDB Functions

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

Note

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
Share on: