Hello, Team.

A .NET app is being developed by our team. We are using Oracle database 18.3.0.

In order to insert date and time in a date column developers use the following code:

TO_DATE(TO_CHAR(:DATE_COLUMN,'DD/MM/RRRR' HH:MI:SS AM), 'DD/MM/RRR' HH:MI:SS AM').

Why do they have to use TO_CHAR in order to insert date and time? Is that correct? What is the best way to insert datetime values into Oracle Database from .NET apps? I thought with TO_DATE(:DATE_COLUMN,'DD/MM/RRR' HH:MI:SS AM') was enough.

Note: We are using spanish date format and because of that we write DD first.

OracleParameter myDateParameter = new OracleParameter();
myDateParameter.OracleDbType = OracleDbType.Date;
myDateParameter.Value = [your .Net datetime value];

Command = new OracleCommand("insert into T values ( :myDateParameter)", connection);