Time Difference in Seconds using Netezza?

netezza, sql

Solution

Did some Searching on the IBM forums and found this which works. If someone comes with better way please do post it. Thanks

    Select 
    R.*,S.*,CM.URL,
    EXTRACT(EPOCH from S.MIN - R.EVENT_DTM)DIFF 
    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

Problem

I want to Get time difference in minutes in Netezza in Seconds. I have 2 columns: `Start(2014-06-01 07:45:04)` and `finish(2014-06-01 07:46:58)` events I have tried Using `DATEDIFF(SECOND,start,finish)`, but Netezza shoots an error. Is there a function I am missing? ``` 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 ```

Original source