EXTRACT()

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

CREATE TABLE t1 (a DATE);

INSERT INTO t1 VALUES
  ('0000-00-00'), ('0000-00-01'),
  ('0000-01-00'), ('0000-01-01'),
  ('0001-00-00'), ('0001-00-01'),
  ('0001-01-00'), ('0001-01-01');

SELECT a, EXTRACT(DAY FROM a) FROM t1;

+------------+---------------------+
| a          | EXTRACT(DAY FROM a) |
+------------+---------------------+
| 0000-00-00 |                   0 |
| 0000-00-01 |                   1 |
| 0000-01-00 |                   0 |
| 0000-01-01 |                   1 |
| 0001-00-00 |                   0 |
| 0001-00-01 |                   1 |
| 0001-01-00 |                   0 |
| 0001-01-01 |                   1 |
+------------+---------------------+

SELECT EXTRACT(HOUR FROM '2019-01-31 10:01:00');

+------------------------------------------+
| EXTRACT(HOUR FROM '2019-01-31 10:01:00') |
+------------------------------------------+
|                                       10 |
+------------------------------------------+

SELECT EXTRACT(YEAR FROM '2019-01-31 10:01:00');

+------------------------------------------+
| EXTRACT(YEAR FROM '2019-01-31 10:01:00') |
+------------------------------------------+
|                                     2019 |
+------------------------------------------+

SELECT EXTRACT(DAY FROM '2019-01-31 10:01:00');

+-----------------------------------------+
| EXTRACT(DAY FROM '2019-01-31 10:01:00') |
+-----------------------------------------+
|                                      31 |
+-----------------------------------------+

SELECT EXTRACT(MINUTE FROM '2019-01-31 10:01:00');

+--------------------------------------------+
| EXTRACT(MINUTE FROM '2019-01-31 10:01:00') |
+--------------------------------------------+
|                                          1 |
+--------------------------------------------+

SELECT EXTRACT(SECOND FROM '2019-01-31 10:01:00');

+--------------------------------------------+
| EXTRACT(SECOND FROM '2019-01-31 10:01:00') |
+--------------------------------------------+
|                                          0 |
+--------------------------------------------+

SELECT EXTRACT(MICROSECOND FROM '2019-01-31 10:01:00.000123');

+--------------------------------------------------------+
| EXTRACT(MICROSECOND FROM '2019-01-31 10:01:00.000123') |
+--------------------------------------------------------+
|                                                    123 |
+--------------------------------------------------------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES