DateTime problem with Acces

[Utghar]

Im currently doing a windows form, i have to get the time and the hour and insert in a database.

Heres my code:
Dim hora As DateTime = DateTime.Now
Me.OleDbDataAdapter1.Fill(DataSet11)
DataSet11.hores.AddhoresRow(hora)
Me.OleDbDataAdapter1.Update(DataSet11)

The problem is that in the database only appears the date, the hour doesn

 

[Robby]

I would change the fields data type to String/Text and the code to...

Dim hora As String = Now.ToLongTimeString