如何在mysql中转换timestamp为普通日期

FROM_UNIXTIME(timestamp/1000,'%Y-%m-%d %h:%i')


eg：

SELECT a.mobile,a.field1,a.field2,a.field3,a.field4,a.field5,b.uid,b.username,b.email,FROM_UNIXTIME(b.regdate,'%Y-%m-%d %h:%i') AS 注册时间 FROM pre_common_member_profile a INNER JOIN pre_common_member b ON a.uid=b.uid WHERE mobile<>''