问题描述:

I get the above error when i run the below code.

UPDATE MANUAL_TRANSACTIONS SET "Created" = TO_DATE(11/18/2013 9:21:44 AM, MM/DD/YYYY hh:mi:ss)

where ID =365020

网友答案:

You should have:

UPDATE MANUAL_TRANSACTIONS
SET "Created" = TO_DATE('11/18/2013 9:21:44 AM', 'MM/DD/YYYY HH:MI:SS AM')
WHERE ID = 365020

Without the single quotes it will surely give you an error. The docs

相关阅读:
Top