MySQL时间相关函数总结

mysql日期和转换函数

SELECT NOW()    -- 2017-10-30 22:06:50SELECT CURDATE()  -- 2017-10-30SELECT CURRENT_DATE()   -- 2017-10-30SELECT CURRENT_TIME()   --  22:06:50SELECT CURRENT_TIMESTAMP()    -- 2017-10-30 22:06:50SELECT DATE_FORMAT(NOW(),'%Y-%m-%d')  -- 2017-10-30

mysql时间戳和转换函数

SELECT UNIX_TIMESTAMP()   -- 1509372410SELECT UNIX_TIMESTAMP(NOW())   -- 1509372410SELECT UNIX_TIMESTAMP('2017-10-30 22:06:50')    -- 1509372410SELECT FROM_UNIXTIME(1509372410)     -- 2017-10-30 22:06:50SELECT FROM_UNIXTIME(1509372410,'%Y/%m/%d %H:%i:%s')   -- 2017/10/30 22:06:50