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
'[.Db .query]' 카테고리의 다른 글
TOP , MAX , INNER JOIN (0) | 2018.10.12 |
---|---|
mssql insert datetime (0) | 2018.10.08 |