DBDate, DBTime, DBTimeStamp, Date
System.Data.OleDb.OleDbType.DBDate = store date only in the database;
System.Data.OleDb.OleDbType.DBTime= store time only in the database;
>>> The wrong one
System.Data.OleDb.OleDbType.DBTimeStamp= store date&time only in the database;
>>> The right one
System.Data.OleDb.OleDbType.Date= store date&time only in the database;
Example:
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TradeTime", System.Data.OleDb.OleDbType.Date, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TradeTime", System.Data.DataRowVersion.Original, null));
System.Data.OleDb.OleDbType.DBTime= store time only in the database;
>>> The wrong one
System.Data.OleDb.OleDbType.DBTimeStamp= store date&time only in the database;
>>> The right one
System.Data.OleDb.OleDbType.Date= store date&time only in the database;
Example:
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TradeTime", System.Data.OleDb.OleDbType.Date, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TradeTime", System.Data.DataRowVersion.Original, null));