Loading

From report I do not want to see the time

Shovan Saha

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
is this string you will get always like first serial number then datetime ?
Manas Mohapatra9y ago
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"));