Oracle-01861 text does not match the Format String

This problem occurs during programming in C. Generally, the time format is incorrect. Generally, the time format uses a STRING object when saving variables, but is recorded using SQL statements.

This problem occurs during programming in C. Generally, the time format is incorrect. Generally, the time format uses a STRING object when saving variables, but is recorded using SQL statements.

This problem occurs during programming in C. Generally, the time format is incorrect.

The time format generally uses a STRING object when saving variables,

However, when you use an SQL statement to input a database, you need to convert the STRING object through TO_DATE ('string', 'yyyy-mm-dd ');

You can also call a stored procedure. You don't need TO_DATE for conversion. You just need to pay the STRING value to the corresponding variable value,

As follows:

OracleParameter [] paras = {
New OracleParameter ("date", OracleType. datetime )};

Paras [0]. Value = MClass. MakeDate;