项目场景:
mysql数据库时间查询不完全
问题描述
SELECT * FROM sequence where ArtifactCode=202207045029 and CreateTime>=“2022-07-04 11:26:36” and CreateTime<=“2022-07-04 11:26:56”
原因分析:
MySQL时间精度较高
解决方案:
将查询中止时间增加1s
SELECT * FROM sequence where ArtifactCode=202207045029 and CreateTime>=“2022-07-04 11:26:36” and CreateTime<=“2022-07-04 11:26:57”