「MySQL」MINUTE関数で時刻から分を取り出す
環境
Windows10 64bit
MySQL 8.0.27
書式
MINUTE( 'hh:mm:ss’ )
MINUTE関数を使用して、時刻から分を取り出します
使用例1
時刻から分を取り出します
mysql> SELECT MINUTE( '12:08:51' );
+----------------------+
| MINUTE( '12:08:51' ) |
+----------------------+
| 8 |
+----------------------+
1 row in set (0.00 sec)
mysql> SELECT MINUTE( '12:08:51' );
+----------------------+
| MINUTE( '12:08:51' ) |
+----------------------+
| 8 |
+----------------------+
1 row in set (0.00 sec)
mysql> SELECT MINUTE( '12:08:51' ); +----------------------+ | MINUTE( '12:08:51' ) | +----------------------+ | 8 | +----------------------+ 1 row in set (0.00 sec)
使用例2
引数に無効な時刻をした場合はNULLが返されます
mysql> SELECT MINUTE( '12:08:91' );
+----------------------+
| MINUTE( '12:08:91' ) |
+----------------------+
| NULL |
+----------------------+
1 row in set, 1 warning (0.00 sec)
mysql> SELECT MINUTE( '12:08:91' );
+----------------------+
| MINUTE( '12:08:91' ) |
+----------------------+
| NULL |
+----------------------+
1 row in set, 1 warning (0.00 sec)
mysql> SELECT MINUTE( '12:08:91' ); +----------------------+ | MINUTE( '12:08:91' ) | +----------------------+ | NULL | +----------------------+ 1 row in set, 1 warning (0.00 sec)