5 Replies Latest reply: Jul 25, 2012 10:43 AM by harry_hhs RSS

    Calculate duration    (creationdate - closuredate)

      Hello,

       

      I'm trying to calculate the duration of creation and closure date.

       

      Tried the following:

       

       

      SQL SELECT
      datumaangemeld                                          AS IN_DATE_creation_date
      datumafgemeld                                                  AS IN_DATE_closure_date,
      datumafgemeld - datumaangemeld                       AS IN_DATE_duration,
      
      
      FROM db; 
      
      

       

      Above code is not working, any suggustions?

       

      I would like to have the data stored as hours:mins:seconds

       

       

      Thanks!

       

       

      Screenshot seems not to be working so here table information:

       

       

       

      IN_DATE_creation_date
      IN_DATE_closure_date
      10/29/2004 9:54:00 PM10/29/2004 9:59:01 PM
      10/30/2004 10:00:00 PM10/30/2004 10:11:01 PM