From report I do not want to see the time

Question

85 01-Mar- 17 12:00:0 0 AM Placid Express Keya ahmed 654321 654 435273. 28 016476 514321 065465 132165 Kuti mia Italy Here 85 is serial number 01-Mar- 17 12:00:0 0 AM is payment date. I do not want to see the time (12:00:0 0 AM). How?

Rafnas T P · Answer

is this string you will get always like first serial number then datetime ?

Manas Mohapatra · Answer

In SQLServer : SELECT CONVERT (DATE GETDATE()) 'DatePart' Date Part -------------- 2013-07-14 In C# DateTime dateOnly = DateTime.Now; Console.WriteLine(dateOnly.ToString(MM/dd/yyyy));