SQL Tip::Comparing pure DATE component of DATE field.

Normally when we need to compare DATE type where only DATE (i.e DD/MM/YYYY) component holds the significant, we need to convert DATE into VARCHAR2 or use TRUNCATE as follows so that only date component is compare(not time):

Read More - Register for Free Membership