①把日期转换为时间戳UNIX_TIMESTAMP
SELECT UNIX_TIMESTAMP(now());
② 时间戳转换成日期
FROM_UNIXTIME
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(now()), '%Y-%m-%d %H:%i:%S');
①把日期转换为时间戳UNIX_TIMESTAMP
SELECT UNIX_TIMESTAMP(now());
② 时间戳转换成日期
FROM_UNIXTIME
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(now()), '%Y-%m-%d %H:%i:%S');