SELECT id,user_id, FROM_UNIXTIME(add_time, '%Y-%c-%d %h:%i:%s' ) as add_date,FROM_UNIXTIME(online_time, '%Y-%c-%d %h:%i:%s' ) as add_date FROM `table` ORDER BY `id` ASC
MYSQL字段时间戳格式查询出时间格式数据
最新推荐文章于 2024-05-10 10:15:00 发布
SELECT id,user_id, FROM_UNIXTIME(add_time, '%Y-%c-%d %h:%i:%s' ) as add_date,FROM_UNIXTIME(online_time, '%Y-%c-%d %h:%i:%s' ) as add_date FROM `table` ORDER BY `id` ASC