MariaDB 日付から指定した単位で値を取得する

環境
MariaDB 10.6.4
Windows 10 Home 64bit

構文
EXTRACT(値 FROM 日付)
日付から指定した単位で値を取得する場合は、「EXTRACT()」を使用します。

使用例
SQL構文
SELECT EXTRACT(YEAR FROM '2023-01-01’),EXTRACT(YEAR_MONTH FROM '2023-01-01’),EXTRACT(MONTH FROM '2023-01-01’);

結果

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
+---------------------------------+---------------------------------------+----------------------------------+
| EXTRACT(YEAR FROM '2023-01-01') | EXTRACT(YEAR_MONTH FROM '2023-01-01') | EXTRACT(MONTH FROM '2023-01-01') |
+---------------------------------+---------------------------------------+----------------------------------+
| 2023 | 202301 | 1 |
+---------------------------------+---------------------------------------+----------------------------------+
+---------------------------------+---------------------------------------+----------------------------------+ | EXTRACT(YEAR FROM '2023-01-01') | EXTRACT(YEAR_MONTH FROM '2023-01-01') | EXTRACT(MONTH FROM '2023-01-01') | +---------------------------------+---------------------------------------+----------------------------------+ | 2023 | 202301 | 1 | +---------------------------------+---------------------------------------+----------------------------------+
+---------------------------------+---------------------------------------+----------------------------------+
| EXTRACT(YEAR FROM '2023-01-01') | EXTRACT(YEAR_MONTH FROM '2023-01-01') | EXTRACT(MONTH FROM '2023-01-01') |
+---------------------------------+---------------------------------------+----------------------------------+
|                            2023 |                                202301 |                                1 |
+---------------------------------+---------------------------------------+----------------------------------+

 

MariaDB

Posted by arkgame