[DataGrid] Date operators not working with date-time values

[m4theushw]

• The issue is present in the latest release.
• I have searched the issues of this repository and believe that this is not a duplicate.

Current Behavior 😯

If the value of a date or dateTime column has the hour and minutes set, most of the filter operators don't work. The only operators that return results are "is on or after/before", but they don't match with values that have the exact date ("is" part).

Expected Behavior 🤔

Filter operators in date columns should consider only the date components (day, month and year). In dateTime columns, the operator should compare the date components and also the hour and minutes components, ignoring the seconds.

Steps to Reproduce 🕹

Steps:

1. Open https://material-ui.com/components/data-grid/demo/#data-grid-demo
2. Apply a "is" filter on "Maturity Date" or "Trader Date"
3. Nothing is returned

Context 🔦

Noticed it while working in #1708.

[dtassone]

you need to include the time to be completely equal

[oliviertassinari]

@dtassone So we should strip the time when the column type is 'date' (not 'dateTime') and we do the sorting & filtering?