Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.
Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).
表如上图所示。
SELECT * FROM vehicle_warning_message v WHERE v.capture_time >= "2023-10-03%" AND v.capture_time <= "2023-11-03%"
此sql查询结果为: 为啥可以显示出2023-11-03日的值,显示不出来2023-10-03日的值,两个日期的值都是当天的最大时间,即"2023-10-03 23:59:59"和“2023-11-03 23:59:59”
都没用LIKE,这那里是模糊匹配。你是把时间转成字符串,当字符串比较了。