Hi,

I have a Date type column where are values in this format

1.1.2012 10:10:11

I need to create a filter which would filter these values by day, month and year.

How would you do it in plain SQL?

I'd create a between filter with 1.1.2012 0:00:00 and 1.1.2012 23:59:59.

I was just wondering if there any other way.

In SQL you can Use DATEPART() function.

Similarly you can use it, by utilising DbFunctionCall