converting DateTime to Date without Time Stamp

Question

1.00/5 (1 vote)

See more:

C#

var date = (from rec in dcBusinessAccountingContext.WorkOrdersReportSP_Results select rec.Date);

Here "var date" will have all date's from WorkOrdersReportSP_Results with time stamp, next i want to convert that Date's to only Date without "Time Stamp" in C#
can anybody plz help me

thanks
Prashanth

Posted 18-Jul-13 7:14am

Member 10070519

Updated 18-Jul-13 7:35am

ridoy

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Silvabolt · Answer 1 · 2013-07-18T07:48:00

Solution 2

You can do:

C#

date = date.Date;

but if you display it, it will still give you a DateTime with the timestamp reset 12:00 AM.

If you want to just display the date part of a DateTime in a grid for example, you can use the use ToString() formatting.

C#

date.ToString("d")
date.ToString("D")

Which will return:

7/18/2013
Thursday, July 18, 2013

Note: Doing ToShortDateString() and ToLongDateString() will give you the same thing respectively

Posted 18-Jul-13 7:48am

Silvabolt

Comments

Member 10070519 19-Jul-13 2:31am

date.ToString("d") this is giving "Cannot implicitly convert error"

Silvabolt 19-Jul-13 9:26am

You have to change your format type to a string and not a datetime.

e.g string dateString = date.ToString("d");

Radu Tirsu · Answer 2 · 2013-07-18T07:16:00

Solution 1

Hello,

Your value is like this

C#

var date = (from rec in dcBusinessAccountingContext.WorkOrdersReportSP_Results select rec.Date);
date = date.Date;

Posted 18-Jul-13 7:16am

Radu Tirsu

Updated 18-Jul-13 7:36am

v2

Comments

Member 10070519 19-Jul-13 2:32am

date = date.Date giving" System.Collections.Generic.IEnumerable<system.datetime?> does not contain definition for 'Date'"

Radu Tirsu · Answer 3 · 2013-07-19T01:18:00

Solution 3

Sorry,

The answer was:

var date = (from rec in dcBusinessAccountingContext.WorkOrdersReportSP_Results select rec.Date).FirstOrDefault();
date = date.GetValueOrDefault().Date;

I forgot to add FirstOrDefault().

But of course you must do the logic if date is null.

Posted 19-Jul-13 1:18am

Radu Tirsu

Comments

Naz_Firdouse 19-Jul-13 7:36am

instead of posting it as another solution, please update your previous answer

converting DateTime to Date without Time Stamp

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

converting DateTime to Date without Time Stamp

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us