You would be better off setting the time zone ahead of time:SET time_zone='UTC';select FROM_UNIXTIME(1277942400);SELECT CONVERT_TZ(FROM_UNIXTIME(1277942400), @@session.time_zone,'UTC')SELECT @@global.
*时间格式转换，使datetimepicker.js 能够搜索 查询 单个 年月日而不需是区间 查询。 //另起一行看转换结果 select *,FROM_UNIXTIME(CreateTime,'%Y-%m-%d') as date from lg_recharge //where条件查询测试 select * from lg_recharge where FROM_UNIXTIME(...
