Distinct Date Search on Date with Time

[chrisrlong]

SELECT DISTINCT trunc(settle_dte) FROM heloc_tracking WHERE settle_dte > TO_DATE('25.7.2001','DD.MM.YYYY') AND settle_dte < TO_DATE('27.7.2001','DD.MM.YYYY') ORDER BY settle_dte

- Chris