Filter by ignoring time from DateTime Field

Nageshwar Rao

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?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
yes you are doing good,
simply you can use datetime datatype..
Nageshwar Rao10y ago
want to use in c# code
Manas Mohapatra10y ago
Try like below:
SELECT *
FROM tblEmp
WHERE Convert(varchAR(10), dateColumn, 103) = '15/05/2012'
Nageshwar Rao10y ago
hi ketan,
i used
DateTime dt = new DateTime();
dt.ToString("dd/MM/yyyy") ;
still it is not getting
ketan borsdiya10y ago
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") ;