title: TimeDiff function in JDBC sql
body: <p>I'm trying to create an sql statement in java that uses the timediff function to compare two sql date objects from a table. This is what my statement looks like:</p>
  
  <pre><code>SELECT EMPLOYEEID, COUNT(ORDER_TYPE) AS BREAKFASTCOUNT, MIN(TIMEDIFF(ORDER_ACCEPTED_TIME,ORDER_COMPLETION_TIME)) AS MINPREP, MAX(TIMEDIFF(ORDER_ACCEPTED_TIME, ORDER_COMPLETION_TIME)) AS MAXPREP FROM ORDERS WHERE ORDERDATE BETWEEN '4/01/2015' AND '4/30/2015' AND ORDER_TYPE ='Breakfast' GROUP BY EMPLOYEEID
  </code></pre>
  
  <p>However, when I run this statement I get the error:</p>
  
  <pre><code>java.sql.SQLSyntaxErrorException: 'TIMEDIFF' is not recognized as a function or procedure.
  </code></pre>
  
  <p>Is there any reason why this error is occurring?</p>