正文

MYSQL 查询指定日期后的15天

IP云
IP云V管理员/0 阅读
08/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