plz solve this

[Ravi Shankar43]

iam selecting the date from calender control into the textbox.when iam inserting into database(sql2ooo) it is showing the time also.i dont want to display time in the frontend(datagrid).what should i do? ravi shankar

[coolestCoder]

hi, use something like this select convert(varchar,getdate(),101) you can use your column name instead of getdate()

---

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

---

coolestCoder

[Ravi Shankar43]

yes thank u i got it