Distinct Date Search on Date with Time

[marist89]

If you are running this query multiple times, you can create a view with the TRUNC() function built-in and select from the view...