Time format

[Mingas]

Please help, i have a colomn in my SQL database called "Actual" it is set to data type "time(8)"

Through a web app designed in asp .net....on Onclick event of a button...I'm trying to take a value of a text box and update my DB table as follow:

string txt = tb.Text;
string query = "Update Jobs Set Actual = 'CONVERT(VARCHAR(8),+ txt +,8)'";



No matter what i try, I keep getting this error:

Conversion failed when converting date and/or time from character string.

 

[jbenson001]

remove the 2 "+" signs from your string

 

[gk53]

change to

string txt = tb.Text;
string query = "Update Jobs Set Actual = 'CONVERT(VARCHAR(8), " + txt + ", 8)'";