- 论坛徽章:
- 0
|
表的结构为
mysql> desc moments;
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| mo_id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(32) | NO | MUL | NULL | |
| mo_content | varchar(250) | NO | | NULL | |
| mo_type | tinyint(1) | NO | | 1 | |
| time | timestamp | NO | | CURRENT_TIMESTAMP | |
| comment_count | int(11) | NO | | 0 | |
| like_count | int(11) | NO | | 0 | |
+---------------+--------------+------+-----+-------------------+----------------+
7 rows in set (0.00 sec)
SELECT CASE WHEN TIMESTAMPDIFF(MINUTE , m.time, now( ) ) <60
THEN TIMESTAMPDIFF(MINUTE , m.time, now( ) )
WHEN TIMESTAMPDIFF(MINUTE , m.time, now( ) ) >60
THEN m.time
END AS time
FROM moments m
结果是:
time
323031352d30362d33302030343a32323a3033
323031352d30362d33302030343a32333a3334
为啥会出现这种情况呢? |
|