C # how to insert date data to Oracle databases

If the Oracle database table contains a Date Field, assume that the field name is time, the date to be inserted is now, now is in string format, and the value is "1900-01-01 ", the following statement fails to insert data:

String. Format ("insert into tablename (time) values ('{0}')", now)

The correct format should be:

String. Format ("insert into tablename (time) values (to_date ('{0}', 'yyyy-MM-DD ')", now)

So there is no problem.

It should be pointed out that the C # has the datetime type, but this type includes hours, minutes, and seconds. This format is inconsistent with the date type in the database. If you set now to datetime, data insertion will fail.

Welcome to my independent technical blogSyntaxes | sameideal.com