Hi guys and thanks to those folks who have answered my questions before, you are a great help :)
Anyway here's my Q for today:
So I have a database table with a time(7) field and I am using visual basic 2010 express to interface with the DB.
when I use this code :
Time_StampTextBox.Text = Date.Now.TimeOfDay.ToString
I get this result
08:18:01.8205871
, the trailing 7 digits are not wanted
I tried using this code:
Dim Arg1 = Date.Now.ToShortTimeString
Time_StampTextBox.Text = Arg1
and I get 8:18 AM which is perfect, but the DB.table wont accept it into the table
and I dont get an error message, ??
also tried this
Format(Arg1, "h:m:s")
but all i got was "h:m:s"
is it to do with the number 7 in the field definition ??, or somthing else?
thanks guys :)