1.3K Star 6.1K Fork 2.9K

GVP季圣华 / 华夏ERP

 / 详情

SQL查询的结束日期错误

Backlog
Opened this issue  
2021-01-07 14:34
SELECT ifnull(sum(discount_last_money), 0) AS allMoney FROM jsh_depot_head dh WHERE dh.tenant_id = 132 AND 1 = 1 AND dh.type = '入库' AND dh.sub_type = '采购' AND dh.oper_time >= '2020-09-01 00:00:00' AND dh.oper_time <= '2020-09-31 23:59:59' AND ifnull(dh.delete_flag, '0') != '1';

9月没有31号,2020-09-31 23:59:59不是一个合法的日期

Comments (1)

YangHeng created任务
YangHeng set related repository to 季圣华/华夏ERP
展开全部操作日志

在作者不修复的情况下,可以通过sql_mode兼容这种错误写法,可以参考 #I2C1IA:无法连接 MySQL8,请将mysql-connector-java版本更新为8.x

YangHeng translation missing: en.project.new_issues_operate_log.link_issue(Normal)无法连接 MySQL8,请将mysql-connector-java版本更新为8.x

Sign in to comment

状态
Assignees
Milestones
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
Branches
Planed to start   -   Planed to end
-
Top level
Priority
参与者(1)
354044 yangheng work 1578921165
Java
1
https://gitee.com/jishenghua/JSH_ERP.git
git@gitee.com:jishenghua/JSH_ERP.git
jishenghua
JSH_ERP
华夏ERP

Search