Depending in what control you show the value you can possibly:
- format the date in the control
- you can format the date before showing it for example using
DateTime.ToShortDateString Method [
^]
- you can remove the time portion when you fetch the data from the database for example by casting the value to date using using
CAST or CONVERT[
^] (if this is Sql Server).