如何从linq中的datetime数据中仅检索日期 [英] how to retrieve only date from datetime data in linq

问题描述

我确实要求检索包含数据库中datetime类型的日期col的数据，现在我应该以dd-mm-yyyy的形式截断日期和返回日期的时间， linq查询 - 我已经搜索了更多的时间来获得这个，但无法以我上面提到的正确格式检索，我的查询如下。

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.

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!!!

推荐答案

DateTime.Date返回DateTime值，时间部分重置为午夜：0小时，0分0秒，所以只需使用它就可以了没有你注释掉的例子中的其他内容应该有效：

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:

CurrentDate = c.CurrentDate.Date,

如果你想把日期作为一个字符串（任何我建议反对它），那么只需使用ToShortDateString方法： MSDN [ ^ ]因为它返回一个适合代码运行的PC文化的字符串。

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.

如果，CurrentDate是您数据库中的实际列想以dd-mm-yyyy格式获取日期。您可以使用此代码，

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,

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

这将要求CurrentDate属于DateTime数据类型。您可以在转换为字符串此处 [ ^ ]。那不是使用ToString，但在这种情况下String.Format（）是相同的。

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.

这篇关于如何从linq中的datetime数据中仅检索日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！