I am trying to display a date on a Gridview but I get the date with the time from an SQL query.  How can I truncate the time from the SQL return?  Or simply just display the date?  My program is in C# and I’m using MS VS 2005.

Thanks!

Jason

 You can try to format the date into string with format of yyyyMMdd

 eg     datetime.ToString("yyyyMMdd")   or (yyyy/mm/dd)

     This will return you just date with this format without time or you can change to whatever format you want
 

Good Luck