查找错误ORA-00932:数据类型不一致:预期DATE得到了NUMBER [英] Lookup Error ORA-00932: inconsistent datatypes: expected DATE got NUMBER

问题描述

当我尝试运行此查询时，出现上述错误.有人可以帮我吗

When I try to run this query I get the above error. Could some one help me on this

UPDATE CCO.ORDER_CREATION 
   SET "Doc_Date" = 8/9/2013 
 WHERE "Document_Number" IN (3032310739,3032310740,3032310738)

推荐答案

尝试一下

UPDATE CCO.ORDER_CREATION 
   SET "Doc_Date" =   TO_DATE('8/9/2013', 'MM/DD/YYYY')
 WHERE "Document_Number" IN (3032310739,3032310740,3032310738)

这篇关于查找错误ORA-00932:数据类型不一致:预期DATE得到了NUMBER的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！