DateTime no Time transferred
-
I have a simple C# app that uses an OleDBDataAdapter on an Access database. One of the fields is a date/time. I insert a new row into the table and the date portion of the date/time is there but the time is always "00:00:00" (the time fields are set properly in the DateTime object when I look at it in the debugger) I tried setting the schema to us DBTimestamp and get an exception thrown during the database update 'type mismatch on criteria query' any ideas on what could be causing or what I need to do to get both the date and time portions of a DateTime to trasfer to a database? thanks!
-
I have a simple C# app that uses an OleDBDataAdapter on an Access database. One of the fields is a date/time. I insert a new row into the table and the date portion of the date/time is there but the time is always "00:00:00" (the time fields are set properly in the DateTime object when I look at it in the debugger) I tried setting the schema to us DBTimestamp and get an exception thrown during the database update 'type mismatch on criteria query' any ideas on what could be causing or what I need to do to get both the date and time portions of a DateTime to trasfer to a database? thanks!
I had to set all my Access date formats (in the table designer) to 'General Date'. The format seems to dictate the output format. Other formats are not fully understood by the ODBC driver (guessing).