To supress the date in the datetime

str=insert into tbl(datermdate) values("& format("{hh:MM:ss}",textbox1.text)
dim da =new sqldataadapter(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

Comments

  • : str=insert into tbl(datermdate) values("& format("{hh:MM:ss}",textbox1.text)
    : dim da =new sqldataadapter(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
    :
    :
    instead of asking for datetime just ask for time? is this what you are asking>?

    ><//~Psightoplasm`~

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion