Форум пользователей MySQL

mysql> select * from t_5647;
+---------------------+
| date                |
+---------------------+
| 2012-04-23 02:10:32 |
+---------------------+
1 row in set (0.00 sec)

mysql> select CONCAT(hour(`date`), ':', minute(`date`)) from t_5647;
+-------------------------------------------+
| CONCAT(hour(`date`), ':', minute(`date`)) |
+-------------------------------------------+
| 2:10                                      |
+-------------------------------------------+
1 row in set (0.00 sec)

mysql> select DATE_FORMAT(`date`, '%H:%i') FROM t_5647;
+------------------------------+
| DATE_FORMAT(`date`, '%H:%i') |
+------------------------------+
| 02:10                        |
+------------------------------+
1 row in set (0.00 sec)