datetime field

Sql server my field is date time and I show it in data grid but it show
12.03.2004 00:00:00 I want the time doesnt show...How can I do that...You can use CONVERT in your query. See below article for more info:
http://www.karaszi.com/sqlserver/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Selen" <skiyanc@.yahoo.com> wrote in message
news:%23YJ675mCEHA.1228@.TK2MSFTNGP11.phx.gbl...
> Sql server my field is date time and I show it in data grid but it show
> 12.03.2004 00:00:00 I want the time doesnt show...How can I do that...
>|||Selen\
Please don't multipost ,I have just answered this question in .programming.
"Selen" <skiyanc@.yahoo.com> wrote in message
news:#YJ675mCEHA.1228@.TK2MSFTNGP11.phx.gbl...
> Sql server my field is date time and I show it in data grid but it show
> 12.03.2004 00:00:00 I want the time doesnt show...How can I do that...
>