¶ÁÊéÈË

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

·¢²¼Ê±¼ä£º 2012-02-06 15:52:45 ×÷Õߣº rapoo

Ϊʲôһֱ±¨ 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'

¶ÁÊéÈËÍø >oracle

ÈȵãÍÆ¼ö