datetime format in asp.net gridview

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

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 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

Method 2

You can also check if you are using Template Field.

<asp:TemplateField HeaderText="Submission Date">
<ItemTemplate>
<%#Eval("dbDate","{0:dd/MM/yyyy HH:mm:tt}")%>
</ItemTemplate>
</asp:TemplateField>

Method 3

Date Time Format with AM/PM:

HtmlEncode="false" DataFormatString="{0:dd/MM/yyyy hh:mm:ss tt}"

Method 4

A suitable format string would be:

{0:MM-dd-yyyy H:mm tt}

A good resource on making custom format strings in .Net can be found at MSDN

Method 5

To format a DATETIME value in a GridView, you can do it like this:

DataFormatString="{0:MM-dd-yyyy hh:mm tt}"

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0