Problem with DateTime

[Tina]

I'm selecting some columns using a .net dataadapter using Select myDate from
myTable. then I...
DIM dt as new datatable
myda.fill(dt)

Now in dubugging I am examining the dt.rows(0).ItemArray (because I didn't
trust what was displaying in my datagrid)

It shows my date as being 8/31/2005 1:26:45 PM. The problem is that the
real date in the database is 8/31/2005 1:26:45:197 PM !!!

Something in the data adapter or something somewhere else is cutting off the
197.

This is a big problem for me because I use this date later in a where clause
for an update and the lack of the 197 is causing the where to fail.

Why is the 197 being cutoff? What can I do about this?

Thanks,
T

 

[Patrick.O.Ige]

Tina maybe it would be nice if you can post more code.
Patrick

 

[Tina]

I'll post a new message because I have more infor now. Thanks for
answering.
T

 

[Patrick.O.Ige]

You are welcome
Patrick

I'll post a new message because I have more infor now. Thanks for
answering.
T