title: how to split the datetime column into date and time and compare individually
body: <p>I have a visit table </p>
  
  <p>with columns </p>
  
  <pre><code>            member_id
             visit_id
             visit_logout_datetime(values like this... '
  </code></pre>
  
  <p>now i need to compare the visit_logout_datetime with today date time property...</p>
  
  <p>here is two conditions </p>
  
  <p>1) i need to <code>compare the today date with date</code> coming from this field visit_logout_datetime</p>
  
  <p>// here i want to do something....</p>
  
  <p>2) i need to compare the  <code>present time with the time in this field</code>  visit_logout_datetime </p>
  
  <p>i want to compare individually ..</p>
  
  <p>how can i do that ..</p>
  
  <p>would any one pls help on this....</p>