How to display datetime in GridView in format MM/dd/yyyy?

Question

I select a table in database into dataset in this table include filed date(smalldatetime). Then I set this dataset to gridView. And column Date of GridView always display MM/dd/yyyy hh:mm:ss like 11/16/2009 4:13:00 PM. How to display only MM/dd/yyyy.

Kirtan Patel · Answer

Here is Code how you can do it Programatically Just change your select Query When getting data From Database --------------------------------------------------------------- select Name Convert(varchar(20)DateOfBirth1) from Employee --------------------------------------------------------------- this will convert DatetimeFormat :) here 1 represent US Short Date time Format MM/dd/yyyy if my answer helps you then check  Do you like this answer check box :) Here are More Formats Format Query USA mm/dd/yy select convert(varchar getdate() 1) ANSI yy.mm.dd select convert(varchar getdate() 2) British/French dd/mm/yy select convert(varchar getdate() 3) German dd.mm.yy select convert(varchar getdate() 4) Italian dd-mm-yy select convert(varchar getdate() 5) dd mon yy select convert(varchar getdate() 6) Mon dd yy select convert(varchar getdate() 7) USA mm-dd-yy select convert(varchar getdate() 10) JAPAN yy/mm/dd select convert(varchar getdate() 11) ISO yymmdd select convert(varchar getdate() 12) mon dd yyyy hh:miAM (or PM) select convert(varchar getdate() 100) mm/dd/yyyy select convert(varchar getdate() 101) yyyy.mm.dd select convert(varchar getdate() 102) dd/mm/yyyy select convert(varchar getdate() 103) dd.mm.yyyy select convert(varchar getdate() 104) dd-mm-yyyy select convert(varchar getdate() 105) dd mon yyyy select convert(varchar getdate() 106) Mon dd yyyy select convert(varchar getdate() 107) hh:mm:ss select convert(varchar getdate() 108) Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM) select convert(varchar getdate() 109) mm-dd-yyyy select convert(varchar getdate() 110) yyyy/mm/dd select convert(varchar getdate() 111) yyyymmdd select convert(varchar getdate() 112) Europe default + milliseconds dd mon yyyy hh:mm:ss:mmm(24h) select convert(varchar getdate() 113) or select convert(varchar getdate() 13) hh:mi:ss:mmm(24h) select convert(varchar getdate() 114)

Josue Vega · Answer

For SQL Convert(varchar(20) ColumnName 20) AS ColumnSameName I use this to import data to a datagridview in c# format the date at query and display the datetime Then I get that information and export to a CSV - Otherwise the format will show dd/mm/yyyy HH:mm tt Result: yyyy-MM-dd HH:mm:ss 2014-11-21 02:03:04

Purushottam Rathore · Answer

Hi Use this .... DataFormatString={0:MM/dd/yyyy} />

Sam Hobbs · Answer

Try this. In the GridView tasks (smart tags?) click on Edit Columns. In the Selected Fields click on the date field. Then in the right half (the BoundField properties) find DataFormatString near the bottom. Enter {0:d} (without quotes) for the DataFormatString.