Matching sql date with .NET date

Question

Should the following always match:

if(mydbrecord.DateField.Date == DateTime.Now.Date)
{...}

where mydbrecord date is the current day? I'm retrieving mydbrecord through linq-sql.

mydbrecord.DateField.Date is in the format '2013-12-19 00:00:00.000'.

Do your mydbrecord.DateField.Date value is Date only or it includes time? — Jade
– Jade, Commented Dec 20, 2013 at 2:09
Ok your comparison won't be equal since current date have time value — Jade
– Jade, Commented Dec 20, 2013 at 3:22
If I do Convert.ToDatetime('2013-12-19 00:00:00.000'), they do equal. — 4thSpace
– 4thSpace, Commented Dec 20, 2013 at 3:24

Jade · Accepted Answer · 2013-12-20 03:24:30Z

1

Do it like this

if(mydbrecord.DateField.Date.ToString("yyyy/MM/dd") == DateTime.Now.Date.ToString("yyyy/MM/dd"))
{...}

answered Dec 20, 2013 at 3:24

Jade

2,9941 gold badge13 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1