MYSQL 查询指定日期后的15天

     SELECT
        s.id,
        s.exhi_id,
        s.commission,
        s.order_main_id,
        s.create_date,
        s.fen_xiao_id,
        s.state,
        s.update_date,
        DATE_ADD(s.ju_ban_end_time,INTERVAL 15 DAY) AS 'juBanEndTime',
        om.order_name AS 'orderName',
        om.order_status AS 'orderStatus'
        FROM
        wx_income_statement s
        LEFT JOIN
        wx_order_main om
        ON s.order_main_id=om.id

 

转载于:https://www.cnblogs.com/SHMILYHP/p/5446560.html