编写数据库脚本时，编辑日期类型字段错误，跪求大神帮助

weixin_58555736 2022-02-17 10:58:21

PROCEDURE USR_QLJFW.T_JOB_JKDT 编译错误

错误：PLS-00103: Encountered the symbol "YYYY" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem return
returning <an exponent (**)> <> or != or ~= >= <= <> and or
like like2 like4 likec between into using || multiset bulk
member submultiset
The symbol "*" was substituted for "YYYY" to continue.
行：12
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'YYYY-MM-DD')';

错误：PLS-00103: Encountered the symbol ")" when expecting one of the following:

. ( * @ % & = - + ; < / > at in is mod remainder not rem
return returning <an exponent (**)> <> or != or ~= >= <= <>
and or like like2 like4 likec between into using || bulk
member submultiset
The symbol "*" was substituted for ")" to continue.
行：12
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'YYYY-MM-DD')';

错误：PLS-00103: Encountered the symbol "YYYY" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem return
returning <an exponent (**)> <> or != or ~= >= <= <> and or
like like2 like4 likec between into using || multiset bulk
member submultiset
The symbol "*" was substituted for "YYYY" to continue.
行：29
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'yyyy-mm-dd')';

错误：PLS-00103: Encountered the symbol ")" when expecting one of the following:

. ( * @ % & = - + ; < / > at in is mod remainder not rem
return returning <an exponent (**)> <> or != or ~= >= <= <>
and or like like2 like4 likec between into using || bulk
member submultiset
The symbol "*" was substituted for ")" to continue.
行：29
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'yyyy-mm-dd')';