[.Db .query]
ORA-01861
혜화초보
2022. 7. 2. 10:04
oracle db problem solving
ORA-01861:literal does not match format string
if your column type yyyy-mm-dd
hint ==>
select cnt3
, build_day
from ( select length( build_day ) as cnt3 , build_day from tb_build_master )
where cnt3 != 8
build_day => No problem even with 'Null'
build_day => If the string length is not 8 => cause problems