mysql sql时间戳格式化语句

FROM_UNIXTIME(c.lastUpdateTime/1000,'%Y-%c-%d %h:%i:%s' ) as updatetime;

 

 

 

select c.roleid, r.username, r.rolename, c.chargeId, c.productId, c.price, c.stone, c.status, FROM_UNIXTIME(c.lastUpdateTime/1000,'%Y-%c-%d %h:%i:%s' ) as updatetime  from charge c, role r where c.roleid=r.id and c.status=2 order by c.lastUpdateTime asc;

 

 

 

 

select c.roleid, r.username, r.rolename, c.chargeId, c.productId, c.price, c.stone, c.status, FROM_UNIXTIME(c.lastUpdateTime/1000,'%Y-%c-%d %h:%i:%s' ) as updatetime, c.lastUpdateTime  from charge c, role r where c.roleid=r.id and c.status=2 and c.lastUpdateTime>=1561648730946  order by c.lastUpdateTime asc;

 

 

 

 

MariaDB [codex_game]> select c.roleid, r.username, r.rolename, c.chargeId, c.productId, c.price, c.stone, c.status, FROM_UNIXTIME(c.lastUpdateTime/1000,'%Y-%c-%d %h:%i:%s' ) as updatetime, c.lastUpdateTime  from charge c, role r where c.roleid=r.id and c.status=2 and c.lastUpdateTime>=1561648730946  order by c.lastUpdateTime asc;