mysql> select curtime();
+-----------+
| curtime() |
+-----------+
| 19:43:34 |
+-----------+
1 row in set (0.00 sec)
mysql> select time(now());
+-------------+
| time(now()) |
+-------------+
| 19:43:34 |
+-------------+
1 row in set (0.00 sec)
mysql> select hour(curtime());
+-----------------+
| hour(curtime()) |
+-----------------+
| 19 |
+-----------------+
1 row in set (0.00 sec)
mysql> select minute(curtime());
+-------------------+
| minute(curtime()) |
+-------------------+
| 43 |
+-------------------+
1 row in set (0.00 sec)
mysql> select second(curtime());
+-------------------+
| second(curtime()) |
+-------------------+
| 34 |
+-------------------+
1 row in set (0.00 sec)
