CODEWITHSUNDEEP
asp.netgridview
Steven Zack
Steven Zack

Reputation: 5104

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

Upvotes: 24

Views: 92689

Answers (5)

Akhilesh Soni
Akhilesh Soni

Reputation: 71

Date Time Format with AM/PM:

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

Upvotes: 7

siddhesh
siddhesh

Reputation: 387

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>

Upvotes: 14

Bala R
Bala R

Reputation: 108937

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

Upvotes: 56

James Johnson
James Johnson

Reputation: 46047

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

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

Upvotes: 4

Scott Ferguson
Scott Ferguson

Reputation: 7830

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

Upvotes: 4

Related Questions