mysql直接插入时间戳

NOW() // 2019-08-28 11:13:34
当前时间戳：UNIX_TIMESTAMP(NOW()) // 1566962000

CURDATE() // 2019-08-28
当前年：YEAR(CURDATE()) // 2019
当前月：MONTH(CURDATE()) // 8
当前日期：DATE(CURDATE()) // 2019-08-28
当前年一月份：CONCAT(YEAR(CURDATE()),’-’,‘01’) // 2019-01

INSERT INTO organization (org_id, created_at, year ) VALUES
(‘001’, UNIX_TIMESTAMP(NOW()), YEAR(CURDATE()),
(‘002’, UNIX_TIMESTAMP(NOW()), YEAR(CURDATE())
(‘003’, UNIX_TIMESTAMP(NOW()), YEAR(CURDATE());