Inserting a datetime type of data into a database into a field of date type requires a conversion type. To_date (' {0} ', ' Yyyy-mm-dd '))

It should be noted that there are datetime types in C #, but this type includes hours, minutes, and seconds. This format does not match the date type in the database, and inserting data if now is set to a datetime type will fail.

Need to be converted via to_date (' field ', ' Yyyy-mm-dd '). As follows:

1. String. Format ("INSERT INTO TableName" (time) VALUES (to_date (' {0} ', ' Yyyy-mm-dd ') " )

Error wording:

1. String. Format ("INSERT INTO TableName (time) VALUES ( ' to_date (' {0} ', ' Yyyy-mm-dd ')' ) ", now)

Do not need a comma to cause, this is superfluous.

Inserting a datetime type of data into a database into a field of date type requires a conversion type. To_date (' {0} ', ' Yyyy-mm-dd '))