注:create_time 为字段名 test 为表名
- int时间类型转为datetime类型
select create_time, FROM_UNIXTIME(create_time) from test;
- datetime时间类型转为int类型
select create_time,unix_timestamp(create_time) from test;
注:create_time 为字段名 test 为表名
select create_time, FROM_UNIXTIME(create_time) from test;
select create_time,unix_timestamp(create_time) from test;