title: Time Difference in Seconds using Netezza?
body: <p>I want to Get time difference in minutes in Netezza in Seconds. </p>
  
  <p>I have 2 columns: <code>Start(2014-06-01 07:45:04)</code> and <code>finish(2014-06-01 07:46:58)</code> events </p>
  
  <p>I have tried Using <code>DATEDIFF(SECOND,start,finish)</code>, but Netezza shoots an error.</p>
  
  <p>Is there a function I am missing?</p>
  
  <pre><code>Select R.*,S.*,CM.URL,DATEDIFF(SECOND,R.EVENT_DTM,S.MIN) From CTE_1 R 
  JOIN CTE_2 S
  on S.VISIT_KEY = R.VISIT_KEY
  JOIN ADMIN.VW_DIM_CME_METADATA CM on CM.CONTENT_METADATA_KEY = R.CONTENT_METADATA_KEY
  </code></pre>