Filter by ignoring time from DateTime Field

Question

Hi

Suppose in my database there is column named"MyDateTime of type DateTime
I want to show user both date & time So we can not do any change in itemsource for ignoring time from date in that field named MyDateTime

Now I am applying filter on that field(MyDateTime) in gridcontrol
I want to only consider date from field MyDateTime for filter

How to do Filter By ignoring Time from column type DateTime ?

If possible then please provide some example

I want to do this because problem is
Suppose in database there is data
15/05/2012 02:30:55

Now I am filtering for this data
If I sellect equals as operator from filter & select date 15/05/2012
then on backend it will select date like 15/05/2012 00:00:00 for filter
so it will not show any result because of time is different

I want to show user both date & time
But I want the filter only consider date from datetime field.Here i am using intersoftgrid

Can you please help me for that?

Bikesh Srivastava · Answer

yes you are doing good, simply you can use datetime datatype..

Nageshwar Rao · Answer

want to use in c# code

Manas Mohapatra · Answer

Try like below: SELECT * FROM tblEmp WHERE Convert ( varchAR (10), dateColumn, 103) = '15/05/2012'

Nageshwar Rao · Answer

hi ketan, i used DateTime dt = new DateTime(); dt.ToString("dd/MM/yyyy") ; still it is not getting

ketan borsdiya · Answer

Hi Nageshwar, If you want to use in SQL then use below query, select Convert(varchAR(10),getdate(),120) OR If you want to use in C# then use below code DateTime dt = new DateTime(); dt.ToString("dd/MM/yyyy") ;

Filter by ignoring time from DateTime Field

Answers (5)