SQL时间格式为“1337686439”,如何转换成普通日期格式 数据库中时间日期存储格式为1337523721,1337523194。如何转化为普通时间日期格式 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> SELECT FROM_UNIXTIME(1337523721);+---------------------------+| FROM_UNIXTIME(1337523721) |+---------------------------+| 2012-05-20 18:22:01 |+---------------------------+1 row in set (0.00 sec) mysql> SELECT FROM_UNIXTIME(1337523721);+---------------------------+| FROM_UNIXTIME(1337523721) |+---------------------------+| 2012-05-20 22:22:01 |+---------------------------+1 row in set (0.00 sec)mysql> SELECT FROM_UNIXTIME(1337523194);+---------------------------+| FROM_UNIXTIME(1337523194) |+---------------------------+| 2012-05-20 22:13:14 |+---------------------------+1 row in set (0.00 sec)mysql> mysql> select from_unixtime(1337523721);+---------------------------+| from_unixtime(1337523721) |+---------------------------+| 2012-05-20 22:22:01 |+---------------------------+1 row in set (0.00 sec) 安装了mysql_memcached的udf,创建触发器时提示错误 急救小弟,请教一个MYSQL查询写法 mysql怎么定义外键 mysql 的奇怪现象 varchar(m)长度问题 急求!mysql存储过程,多个字段合并后通过一个输出变量参数返回值. MySQL怎样处理.sql文件? mysql的视图能传参数吗 嵌套查询 外键 postgresql 能删除数据文件 MYSQL停止/启用不了
+---------------------------+
| FROM_UNIXTIME(1337523721) |
+---------------------------+
| 2012-05-20 18:22:01 |
+---------------------------+
1 row in set (0.00 sec)
+---------------------------+
| FROM_UNIXTIME(1337523721) |
+---------------------------+
| 2012-05-20 22:22:01 |
+---------------------------+
1 row in set (0.00 sec)mysql> SELECT FROM_UNIXTIME(1337523194);
+---------------------------+
| FROM_UNIXTIME(1337523194) |
+---------------------------+
| 2012-05-20 22:13:14 |
+---------------------------+
1 row in set (0.00 sec)mysql>
+---------------------------+
| from_unixtime(1337523721) |
+---------------------------+
| 2012-05-20 22:22:01 |
+---------------------------+
1 row in set (0.00 sec)