datetime format in asp.net gridview

Question

I need to display a datetime column in my gridview, but I don't want to show millin second for sure. How do I set the format string in gridview to display a datetime data in following format: 08-19-2007 11:09 AM

Answer 1

Use the appropriate DataFormatString for the bound field.

<asp:BoundField DataField="YourDateField" HeaderText="SomeHeader" 
                    DataFormatString="{0:MM-dd-yyyy hh:mm tt}"  />

Alternatively, you could use DateFormatString="{0:g}" which is the general date/time pattern (short time). It would produce something like 08/19/2007 11:09 AM