title: Paradox: Query a Date column + a Time column as a DateTime
body: <p>First off, I'm a Paradox newbie.
  <br>Secondly, I'm querying a database of a third-party software package and cannot change the schema.</p>
  
  <p>I have two fields simply named "Date" and "Time" that I'd like to query as a DateTime (from my MS SQL experience).</p>
  
  <p>Is this possible?</p>
  
  <p>I've tried several queries and, when the command is valid, I get "Data type mismatch in criteria expression."  </p>
  
  <p>Also, this would be from a Paradox database from about 1999-2000 if that makes any difference.</p>
  
  <p>EDIT:  Even a simple string concatenation of the fields would a great help because I could handle that in code.</p>
  
  <p>EDIT:  In response to a.i.breveleri's answer.  I get this message:</p>
  
  <blockquote>
    <p>ERROR [42000] [Microsoft][ODBC Paradox
    Driver] Syntax error (missing
    operator) in query expression
    'CAST(m.DateComplete AS TIMESTAMP) - 
                  CAST([1/1/3000] AS TIMESTAMP) + 
                  CAST(m.TimeComplete AS TIMESTAMP)'.</p>
  </blockquote>
  
  <p>When I run this query:</p>
  
  <pre><code>select distinct 
    CAST(m.DateComplete AS TIMESTAMP) - 
    CAST("1/1/3000" AS TIMESTAMP) + 
    CAST(m.TimeComplete AS TIMESTAMP)
  from Mean m 
  </code></pre>