Putting in Access 97, a DateTime 'date' usingVB.NET

[robcrann]

I want to put, in an Access 97 database, using the Access 'Date/Time' datatype, a 'time', using VB.NET with OleDB.

I start with the time converted to number of seconds.
eg

Dim long Time = 3661 '(Equivalent to 01:01:01)

This I incorporate into a query after preceding it with a '.':

"INSERT INTO Data_Set VALUES(.3661)"

Trouble is, it comes out in access as 10:18:47!

What am I doing wrong?

[Rabbit]

That's not how a time is stored in Access. The decimal portion of a date time value does not represent the number of seconds elapsed. It represents the percentage of the day that has elapsed. Besides, there's no reason to separate out and store only the time. Just store the full date time value and display just the time.

[robcrann]

Access from VB.Net

That's not how a time is stored in Access. The decimal portion of a date time value does not represent the number of seconds elapsed. It represents the percentage of the day that has elapsed. Besides, there's no reason to separate out and store only the time. Just store the full date time value and display just the time.

I succeded in converting the percentage of the day to seconds so am happy - Thanks for your reply anyway. Rob