1.bigint转成日期
SELECT from_unixtime(1496825724987/1000)
示例:
starttime字段的类型是:`starttime` bigint(20) NOT NULL DEFAULT '0' COMMENT '任务的开始时间'
执行:
SELECT from_unixtime(starttime/1000) FROM xxx_table;
2.日期转成bigint
SELECT unix_timestamp("2018-11-20 21:44:30") * 1000
示例:
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录的创建时间'
执行:
SELECT unix_timestamp(create_time) *1000 FROM `xxx_table`