title: Oracle date comparison in where clause
body: <p>For eg I have a student table with a DOJ(date of joining) column with its type set as DATE now in that I have stored records in dd-mon-yy format. </p>
  
  <p>I have an IN param at runtime with date passed as string and its in dd/mm/yyyy format. How do I compare and fetch results on date?</p>
  
  <p>I want to fetch count of records of students who have DOJ of 25-AUG-92 per my database table student, but I am getting date as varchar in dd/mm/yyyy format in an IN param, kindly please guide. </p>
  
  <p>I have tried multiple options such as <code>trunc</code>, <code>to_date</code>, <code>to_char</code> but, unfortunately nothing seems to work.</p>