MySQL
1、int时间转换为datetime时间
FROM_UNIXTIME(reg_time)
select reg_time, FROM_UNIXTIME(reg_time) from crm_user;
2、datetime时间转换为int时间
unix_timestamp(reg_time)
select reg_time,unix_timestamp(reg_time) from crm_user;
转载于:https://blog.51cto.com/virusswb/1527329