title: How to separate date and time from a datetime?
body: <p>I have a table with a datetime record.
  I need to select the record using date or time.</p>
  
  <p>Let's say that I have this format <code>1/1/2001 13:33:00</code> in the database  </p>
  
  <p>My question is: If I enter the date, the time or both, I should obtain the rows that have either same date or the same time. <strong>How can I achieve this</strong>?</p>
  
  <p>The convert function <code>CONVERT(VARCHAR(10), Travel.Travel_DateTime, 110)</code> 
  returns the dates if their time is like the default <code>00:00:00</code> </p>