title: How to convert a DATE column to DATETIME in SQL, querying an Access database?
body: <p>I have a SQL query to where I need to convert a <code>DATE</code> column to <code>DATETIME</code> from an Access database.</p>
  
  <p>The columns to be converted are:</p>
  
  <pre><code>CHECKINOUT.CHECKTIME
  CHECKINOUT.DefaultIn
  CHECKINOUT.DefaultOut
  </code></pre>
  
  <p>This is my query: </p>
  
  <pre><code>SELECT       
     USERINFO.NAME, USERINFO.EmployeeCode, CHECKINOUT.CHECKTYPE,
     CHECKINOUT.DefaultIn, CHECKINOUT.DefaultOut, CHECKINOUT.DefaultBreckIn, 
     CHECKINOUT.DefaultBreakOut, CHECKINOUT.CHECKTIME, USERINFO.TITLE
  FROM           
     (CHECKINOUT 
      INNER JOIN USERINFO ON CHECKINOUT.USERID = USERINFO.USERID)
  WHERE 
     (CHECKINOUT.CHECKTIME &gt;= ?) 
     AND (CHECKINOUT.CHECKTIME &lt;= ?) 
     AND (CHECKINOUT.USERID = ? OR ? = - 1) 
     AND (CHECKINOUT.DefaultIn &lt;=  CHECKINOUT.CHECKTIME OR
          CHECKINOUT.DefaultOut &gt;= CHECKINOUT.CHECKTIME )
  </code></pre>
  
  <p>What's the best way?</p>
  
  <p>Thanks </p>