[步骤]
生产上加上0-5点的时间限制后,没有跑出数据
SELECT
StockType ,
CONVERT(DATE, AddTime) AS Day,
COUNT(id) AS TotalID
FROM
RB_Amazon_Fba_StockDetail
where AddTime>'2025-04-01'
and StockType=2
GROUP BY
CONVERT(DATE, AddTime),StockType

[结果]
[期望]
[步骤]
生产上加上0-5点的时间限制后,没有跑出数据
SELECT
StockType ,
CONVERT(DATE, AddTime) AS Day,
COUNT(id) AS TotalID
FROM
RB_Amazon_Fba_StockDetail
where AddTime>'2025-04-01'
and StockType=2
GROUP BY
CONVERT(DATE, AddTime),StockType

[结果]
[期望]
| 由谁创建 | 陈丽婷 于 2025-05-08 09:38:27 |
|---|---|
| 影响环境 |
测试环境-测试反馈 |
| 由谁解决 | 王地福 于 2025-05-08 09:44:43 |
| 解决版本 | |
| 解决方案 | 程序BUG |
| 由谁关闭 | 陈丽婷 于 2025-05-08 19:52:34 |
| 最后修改 | 陈丽婷 于 2025-05-08 19:52:34 |
| 相关Bug |
|---|