I have noticed that dateTimes inserted in my Access 

database now are truncated to dates.



I still have the full datetime in my dataset, and 

dates from the database are not truncated when

loaded into the dataset.



This used to work correctly, when looking back

it seems like the problem started when I upgraded

to Release Candidate 1 from Beta 2.



Any clues?

ANY TECHNIQUES FOR DEBUGGING WHAT GOES INTO THE DATABASE?



Thanks!

Olav

I have NOT experienced the problem.  Look for the problem in your code.



----- Original Message -----

From: "Olav Benum" <wrox@b...>

To: "ADO.NET" <ado_dotnet@p...>

Sent: Monday, February 18, 2002 1:09 AM

Subject: [ado_dotnet] DateTimes truncated to Dates after upgrading to RC1.





> I have noticed that dateTimes inserted in my Access

> database now are truncated to dates.

>

> I still have the full datetime in my dataset, and

> dates from the database are not truncated when

> loaded into the dataset.

>

> This used to work correctly, when looking back

> it seems like the problem started when I upgraded

> to Release Candidate 1 from Beta 2.

>

> Any clues?

> ANY TECHNIQUES FOR DEBUGGING WHAT GOES INTO THE DATABASE?

>

> Thanks!

> Olav




$subst('Email.Unsub').

I wrote

> I have noticed that dateTimes inserted in my Access 

> database now are truncated to dates.

VS genererates this line:

this.oleDbUpdateCommand8.Parameters.Add(new 

System.Data.OleDb.OleDbParameter("LastTest", 

System.Data.OleDb.OleDbType.DBDate, 0, "LastTest"));

	

Changing .DBDate to .Date corrects the problem.

And it seems like the generated code was different before.



Olav