title: How to use date variable in sql developer's "Enter Binds" dialog?
body: <p>I am trying to run a query from sql developer and query has variables (<code>:var</code>). I am having problem with the date variables.</p>
  
  <p>I used all the possible combinations to format date using <code>to_date()</code> function. 
  Every time getting below exception:</p>
  
  <pre><code>ORA-00932: inconsistent datatypes: expected DATE got NUMBER
  00932. 00000 -  "inconsistent datatypes: expected %s got %s"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Sorry can't post image here</p>