Is is possible to make index over datepart in datetime column?

For example, i want to make index over dd-mm-yyyy not including hh:mm:ss, or sometimes only mm-yyyy. Is this possible?Yes, that's possible, create a view and then index your view.