1.获取某天(这里获取2018年1月1日)
SELECT t_kaoqin.`kq_id`,t_kaoqin.`kq_time`,t_kaoqin.`ka_state`,t_kaoqin.`user_id`,t_kaoqin.`p_id`
FROM t_kaoqin
WHERE t_kaoqin.`p_id`=701 AND DATE(t_kaoqin.`kq_time`) = DATE('2018-1-1')
2.获取某月(这里获取2018年1月)
SELECT t_kaoqin.`kq_id`,t_kaoqin.`kq_time`,t_kaoqin.`ka_state`,t_kaoqin.`user_id`,t_kaoqin.`p_id`
FROM t_kaoqin
WHERE t_kaoqin.`p_id`=701 AND YEAR(t_kaoqin.`kq_time`) = 2018 AND MONTH(t_kaoqin.`kq_time`)=1
3.日期时间比较
SELECT
id AS couponId,name,cash,limit_order_price AS limitOrderPrice
FROM
t_coupon
WHERE
t_coupon.`shop_id`=#{shopId}
AND t_coupon.`deleted`=0
<![CDATA[ AND UNIX_TIMESTAMP(t_coupon.`stime`) < UNIX_TIMESTAMP(NOW())]]>
<![CDATA[ AND UNIX_TIMESTAMP(t_coupon.`etime`) > UNIX_TIMESTAMP(NOW())]]>