title: How to get timestamp for date column in oracle sql?
body: <p>I am having a table name called "users". It has one column named "logondt" in which it will show only in this format <code>mm:dd:yy</code> like <code>04-JUN-14</code>.
  But I need to use select query to find in which time, the user is logged in.</p>
  
  <p>I tried something like this..</p>
  
  <pre><code>select logondt from users where logondt between to_date('2014-06-03' ,'yyyy-mm-dd') and to_date('2014-06-03' ,'yyyy-mm-dd') and userid='12345';
  </code></pre>
  
  <p>Is it possible?</p>