DateTime comparison without time part?

Question

I wrote this code. But I want to ignore time, I want to compare only day.

from s in sayac_okumalari
where s.okuma_tarihi == startDate && s.sayac_id == sayac_id
group s by new { date = new DateTime(((DateTime)s.okuma_tarihi).Year, ((DateTime)s.okuma_tarihi).Month, ((DateTime)s.okuma_tarihi).Day, ((DateTime)s.okuma_tarihi).Hour, 1, 1) } into g
select new
{
     okuma_tarihi = g.Key.date,
     T1 = g.Sum(x => x.toplam_kullanim_T1),
     T2 = g.Sum(x => x.toplam_kullanim_T2),
     T3 = g.Sum(x => x.toplam_kullanim_T3)
};

for example:

25.02.1987 == 25.02.1987

Possible duplicate of [How to compare only Date without Time in DateTime types in C#?](http://stackoverflow.com/questions/683037/how-to-compare-only-date-without-time-in-datetime-types-in-c) — Veverke, Dec 21 '16 at 09:26

Ramesh · Accepted Answer · 2012-07-24T07:03:01.537

17

use s.okuma_tarihi.Value.Date == startDate.Date. This should allow you to compare only the Date component.

Update From the discussion in comments looks like the user is using NullableType. Hence updated the solution for NullableType.

edited Jul 24 '12 at 07:03

answered Jul 24 '12 at 06:51

Ramesh

13,043
3
52
88

's.okuma_tarihi' does not contain a definition for 'Date' – AliRıza Adıyahşi Jul 24 '12 at 06:54
Looks like from your code snippet, you need to typecast s.okuma_tarihi to DateTime – Ramesh Jul 24 '12 at 06:57
s.okuma_tarihi.Value.Date == startDate.Date is working.If edit your solution I will mark it. Thanks. – AliRıza Adıyahşi Jul 24 '12 at 06:57
((DateTime)s.okuma_tarihi).Date use only calling, assigment. – AliRıza Adıyahşi Jul 24 '12 at 06:58
Updated. But, looks like you are using Nullable type. You may need to ensure that Nullable type has value before performing action. – Ramesh Jul 24 '12 at 06:59
This is usefull knowledge for me. Thanks a lot. – AliRıza Adıyahşi Jul 24 '12 at 07:01

score 8 · Answer 2 · answered Jul 24 '12 at 06:52

8

Use Date property of DateTime. For ex,

var date= DateTime.Now.Date;

answered Jul 24 '12 at 06:52

L.B

114,136
19
178
224

score 2 · Answer 3 · answered Jul 24 '12 at 07:11

Because you could convert s.okuma_tarihi to DateTime, I think you could do:

var sonuc = from s in sayac_okumalari
        where (DateTime)s.okuma_tarihi.Date == startDate.Date && s.sayac_id == sayac_id
        group s by new { date = new DateTime(((DateTime)s.okuma_tarihi).Year, ((DateTime)s.okuma_tarihi).Month, ((DateTime)s.okuma_tarihi).Day, ((DateTime)s.okuma_tarihi).Hour, 1, 1) } into g
        select new
        {
             okuma_tarihi = g.Key.date,
             T1 = g.Sum(x => x.toplam_kullanim_T1),
             T2 = g.Sum(x => x.toplam_kullanim_T2),
             T3 = g.Sum(x => x.toplam_kullanim_T3)
        };

Hope it helps.

score 0 · Answer 4 · answered Sep 03 '17 at 20:10

Try using the Date property on the DateTime Object will be a good a simple solution.

string AdmissionDate = "10/15/2017" // mm/dd/yyyy
string DepartureDate = "10/14/2017" // mm/dd/yyyy

if (Convert.ToDateTime(AdmissionDate).Date > Convert.ToDateTime(DepartureDate).Date)
{
    // Validation: Admission Date can not be greater than Departure Date... 
}

Almamun · Answer 5 · 2017-07-11T03:06:56.650

-1

Try this...

        try
        {
         DateTime Date1= DateTime.ParseExact(txtBox1.Text,"dd/MM/yyyy",null);
         DateTime Date2 = DateTime.ParseExact(txtBox2.Text, "dd/MM/yyyy", null);

          if (Date1 > Date2) 
          {
           //........
          }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }

edited Jul 11 '17 at 03:06

answered Jul 11 '17 at 03:01

Almamun

11
3

DateTime comparison without time part?

5 Answers5