ORA-01861

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