Date compare in a linq query

Question

drax12 0 Newbie Poster

13 Years Ago

Hey guys,

I'm want to retrieve results from the database, where datetime picker given value, is equal to database value.

           var _check = (from day in Check.tbl_employees
                         where day.d_from== _frm && day.d_to == _to
                       select new
                       {
                           day.desg_id,
                       }).FirstOrDefault();

datetime picker gives a value with its time,but i'm only interested in date.so i need help to compare in date which gives from the datetime picker(_from and _to) in database value(day.d_from,day.d_to).
And when comparing dates,does it compare time too?
need help ASAP.
thanks in advance.

drax

asp.net

Edited 11 Years Ago by Dani because: Formatting fixed

1 Contributor
1 Reply
713 Views
6 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by drax12

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

drax12 0 Newbie Poster · Answer 1 · 2011-06-07T10:20:26+00:00

Hey guys,

I'm want to retrieve results from the database, where datetime picker given value, is equal to database value.

           var _check = (from day in Check.tbl_employees
                         where day.d_from== _frm && day.d_to == _to
                       select new
                       {
                           day.desg_id,
                       }).FirstOrDefault();

datetime picker gives a value with its time,but i'm only interested in date.so i need help to compare in date which gives from the datetime picker(_from and _to) in database value(day.d_from,day.d_to).
And when comparing dates,does it compare time too?
need help ASAP.
thanks in advance.

drax

i found the way,
its simple.

date has to be datetimepicker.value.day