正文

mysql sql时间戳格式化语句

IP云
IP云V管理员/3 阅读
08/07
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

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;