toughest general question ever(date/time picker)!

[titan7262]

i am using MS ACCESS as my database and a date/time picker. the problem is if the value of the date/time picker is at 12:00:00 the it returns only the date.
i.e
if the value of btpTo is 01/01/2004 12:00:00 am it only retuns 01/01/2004 which is the date. the problem is i nee to get the exact date/time. any one has an idea on this?! hehehe





to be clear.

my database has:

fieldname: mydt
data type: date/time format: general date

my code in VB:

rs.open "select * from myDB where id = 1",cn,1,1
rs.addnew
rs!mydt = "12/12/2004 12:00:00 am"
rs.update

result when saved into dbase.

mydt(fieldname)
12/12/2004



time is missing! it should be 12/12/2004 12:00:00 am