title: How to convert a value into static value in oracle/sql
body: <p>say i have </p>
  
  <pre><code>select * from table1
  join table2
  on table1.name = table2.name
  where table1.date = table2.date
  </code></pre>
  
  <p>if in this case table2.date = '13-NOV-13 12.00.00.000000 AM'
  i want to convert table2.date in to static value
  something like <code>where table1.date = somefunction(table2.date)</code>
  so it'll be </p>
  
  <pre><code>where table1.date = '13-NOV-13 12.00.00.000000 AM'
  </code></pre>
  
  <p>how do you do this in oracle 11g.
  Thanks!</p>