Date Time question

[mark]

Hello

I search SQL DB and display results to an APS.Net page using <asp:repeater
/>

One of the columns is a Date in the Database SmallDate .

When I display it the page it shows Date and Time. How can I get rid of Time
and have only date displayed.

All help is greatly appreciated.

Mark

 

[Elton Wang]

If you are using DataBinder.Eval method, you can pass third parameter,
format string:

DataBinder.Eval(Container.DataItem, "DateTime_field", "{0:MMM dd yyyy}")

HTH