how to retrieve only date from datetime data in linq

Question

0.00/5 (No votes)

See more:

Hi, all i do have a requirement that to retrieve data which consists of date col which of type datetime in database, now i should truncate time from date and return date in the form of "dd-mm-yyyy" , in linq query- i have searched lot more time to get this, but unable to retrieve in a proper format which i have mentioned above, my query is as follows.

C#

IEnumerable<object> objs = (
                from c in this.SPE.Consultants.DefaultIfEmpty<consultant>()
                join r in this.SPE.Recruiters on c.Recruiter equals r.RecruiterId
                join e in this.SPE.States on c.CurrentState equals (int?)e.StateId
                join f in this.SPE.SkillSets on c.SkillSet equals (int?)f.SkillSetId
                join t in this.SPE.Teams on c.Recruiter1.Team equals t.TeamId

                where !c.IsDeleted && (c.Status == chosenvalue) //&& r.IsDeleted == false
                orderby f.SkillSetName
                // where !c.IsDeleted && r.RecruiterId == recid && r.IsDeleted == false
                select new
                {
                    ConsultantId = c.ConsultantId,
                    CurrentDate = c.CurrentDate,---actual column
                  //  CurrentDate = (c.CurrentDate.Date + "-" + c.CurrentDate.Month + "-" + c.CurrentDate.Year)---tried way of one format[and lot more tried],
                    Name = (c.FirstName + " ") + (c.LastName != null ? c.LastName : " "),
                   // CurrentLocation = e.StateName + (c.RelocationArea != null ? " [ " + c.RelocationArea + " ]" : " "),
                    CurrentLocation = e.StateName,
                    RelocationPreference = c.RelocationPreference,
                    RelocationArea = c.RelocationArea,
                    PhoneNumber1 = c.PhoneNumber1,
                    PhoneNumber2 = c.PhoneNumber2,
                    EMailId1 = c.EMailId1,
                    EMailId2 = c.EMailId2,
                    Recruiter = r.RecruiterName,
                    SkillSet = f.SkillSetName,
                    Team = t.TeamName,
                    Reference = c.Reference,
                    OtherComments = c.OtherComments,
                    WorkStatus = c.WorkStatus,
                    Status = c.Status,
                    FieldStatus = (EntityFunctions.DiffDays((DateTime?)c.CurrentDate, (DateTime?)DateTime.Today) > (int?)30 ? "YesWithMonthCrossed" : "No")
                }).AsEnumerable<object>();
            return objs;

please help me to solve this!!!

Posted 18-Nov-14 2:10am

pavan_ kumar

Updated 18-Nov-14 2:12am

King Fisher

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2014-11-18T02:20:00

DateTime.Date returns the DateTime value with the time portion reset to midnight: 0 hours, 0 minues 0 seconds, so just using that on it's own without the other stuff in your commented-out example should work:

C#

CurrentDate = c.CurrentDate.Date,

If you want the date as a string (any I'd advise against it), then just use the ToShortDateString method: MSDN[^] as that returns a string appropriate to the culture of the PC the code runs on.

Afzaal Ahmad Zeeshan · Answer 2 · 2014-11-18T02:14:00

If, CurrentDate is the actual column in your database and you want to get the Date in the dd-mm-yyyy format. You can use this code for that,

C#

// Convert the CurrentDate object to string, using a format
c.CurrentDate.ToString("dd-mm-yyyy");

This would require that the CurrentDate is of DateTime data type. You can learn about more formatting for DateTime while converting to string here[^]. That is not using a ToString, but String.Format() is the same in this case.

how to retrieve only date from datetime data in linq

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0