Oracle Insert Time

Symptom: Oracle Insert time, Error: ORA-01861: text does not match format string

Workaround:

This error usually occurs on the time field, that is, the time format you inserted is inconsistent with the existing time format of the database, and the solution is to format the time you inserted: To_date (' # ', ' Yyyy-mm-dd hh24:mi:ss ')

This ORA-01861 won't be reported when this is inserted.

When using PL/SQL Developer Text Importer, you will often encounter this error, due to PL/SQL developer bug, sometimes you can not format all the date column, you need to manually format the date column

Original address: http://blog.csdn.net/wyzxg/article/details/2729507

Oracle Insert Time