mysql 查询时间戳格式化 和thinkphp查询时间戳转换

thinkphp框架

格式化时间戳

$data = $model->field('id,title,FROM_UNIXTIME(time,"%Y-%m-%d %H:%i:%s") as addtime')->order('id desc')->select();
            

 

时间格式变成时间戳

$data = $model->field('id,title,UNIX_TIMESTAMP(time) as addtime')->order('id desc')->select();