µ±Ç°Î»Ö㺠´úÂëÃÔ >> Oracle¼¼Êõ >> Ϊʲôһֱ±¨ ORA-00927Òì³££¨±¨´ísqlÈçÏ£©
  Ïêϸ½â¾ö·½°¸

Ϊʲôһֱ±¨ ORA-00927Òì³££¨±¨´ísqlÈçÏ£©

Èȶȣº105   ·¢²¼Ê±¼ä£º2016-04-24 08:37:19.0
Ϊʲôһֱ±¨ ORA-00927´íÎ󣨱¨´ísqlÈçÏ£©
SQL code
update table set to_date(holiday_end,'yyyy-MM-dd') = to_date('2011-12-21','yyyy-MM-dd')where worker_id='10589'  and HOLIDAY_TYPE='¿õ ¹¤'  and holiday_state='0' 


´ó¼Ò°ïæ¿´ÏÂÎÊÌâÔÚÄÄ£¿Ó¦¸ÃÈçºÎ¸Ä£¬Ð»Ð»

------½â¾ö·½°¸--------------------
update table 
set to_date(holiday_end,'yyyy-MM-dd') = '2011-12-21'
where worker_id='10589'
and HOLIDAY_TYPE='¿õ ¹¤'
and holiday_state='0'