bigint转date from_unixtime(bigint/1000); date转bigint UNIX_TIMESTAMP('2017-05-19 17:01:31'); 转载于:https://my.oschina.net/NeverMoreMoon/blog/904523