title: how to use = assignment operator with timestamp date column in oracle
body: <p>I'm using timestamp in dat column in table r3. when I fire command </p>
  
  <pre><code>select dat from r3 where dat='16-nov-09';
  </code></pre>
  
  <p>it shows "no rows selected" but when i fire command </p>
  
  <pre><code>select dat from r3 where dat&gt;'15-nov-09';
  </code></pre>
  
  <p>it shows the whole data of 16-nov-09. Tell me what is wrong in my first command or what i have to do.</p>