SELECT NOW(),CURDATE(),CURTIME(),
-- datetime 转 date time
NOW(), DATE(NOW()), TIME (NOW()), CONCAT(DATE(NOW()), ' ', TIME (NOW())),
-- str 转 datetime date time
str_to_date('2019-04-25 08:50:00', '%Y-%m-%d %H:%i:%s'),DATE('2019-04-25 08:50:00'),TIME ('2019-04-25 08:50:00'),
str_to_date('2019-04-25 08:50:00', '%Y-%m-%d %T'),
-- 比较
NOW() = CONCAT(DATE(NOW()), ' ', TIME (NOW())),
DATE(NOW()) = '2019-04-25',
NOW() = DATE(NOW()),
NOW() = TIME (NOW());
01.jpg
02.jpg
统计180天前的数据
select
count(*)
from
table_name
where
ctime<UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 180 DAY))
