title: DATETIME Function in SELECT Statement
body: <p>Why does the DATEIME conversion in the SELECT statement below produce a 210056 SQL syntax error?  "act_start_dt" is a DATE type formatted as '2015-01-01' and "act_start_tm" is an integer represented number of seconds since midnight.</p>
  
  <p>The statement works fine without the DATETIME call.</p>
  
  <pre><code>SELECT TOP 100
      act_start_dt,
      act_start_tm,
      DATETIME(act_start_dt, act_start_tm)
  FROM
      PUB.MyTable;
  </code></pre>
  
  <p>The date and time columns are defined as:</p>
  
  <pre><code>act_start_dt[date(10) DEFAULT NULL]
  act_start_tm[integer(10) DEFAULT 0]
  </code></pre>