To supress the date in the datetime

[Anonymous]

str=insert into tbl(datermdate) values("& format("{hh:MM:ss}",textbox1.text) dim da =new sqladapter(str,cn) da.fill(ds,"tbl") I am trying to insert a value into table tbl from textbox where I am giving only the time in the format 2:4:34.But it is taking as datetime value and not as time.Kindly advise