title: How can I compare date in oracle sql without using to_date /to_char function?
body: <pre><code>    select count(*) as a 
      from event 
      where eventName='ARTICLE' 
      and to_char(event_date,'DD-MM-YYYY')= '08-04-2016';
  </code></pre>
  
  <p>I want to compare date using a specific date format but when I run this query it is taking  lot of time. Is there any way which I can get same result with minimum time?</p>