Oracle版本11g
下列两个sql区别是多了一个APPLY_DATE查询条件,前者会报错ORA-01722: 无效数字
后者不会报错,原因是什么?
SELECT NVL (SUM (B_WEIGHT), 0)
FROM V_TABLE
WHERE XXX= '例子' AND APPLY_DATE > 2024-01-23
SELECT NVL (SUM (B_WEIGHT), 0)
FROM V_TABLE
WHERE XXX= '例子' AND APPLY_DATE > 2024-01-23 AND APPLY_DATE < 2024-01-24