title: ORA-00936 When using date function in the oracle select statement
body: <p>I have a query that I'm trying to aggregate data based on hours between two unix timestamps in  Oracle. Hardest part is that I get error'd out with "<em>ORA-00936: missing expression</em>" error even I don't see anything wrong in the query. Need some expert advice here. Below is the query -</p>
  
  <p>Query - </p>
  
  <pre><code>select DATE(FROM_UNIXTIME(C.DATETIMEORIGINATION)) the_date,
  HOUR(FROM_UNIXTIME(C.DATETIMEORIGINATION)) the_hour,
  count(c.RECORD_ID) the_count 
  FROM TABLE_A C 
  WHERE C.DATETIMEORIGINATION between 1380033019 AND 1379702408 
  GROUP BY 1,2;
  </code></pre>
  
  <p>Any help is greatly appreciated. Thanks</p>