1 Reply Latest reply: Dec 20, 2012 6:45 PM by JV123 RSS

    Timestampdiff() function: result in  millisecond

    953689
      Hello,
      I'm using the OBIEE timestampdiff() to calculate the difference between two timestamps, before to continue to use this function I want to check if the function can calculate the delay in second and give result like this example:
      TIMESTAMPDIFF(SQL_TSI_SECOND, CAST("LOGFILE_VORDEL"."DATE_HOUR" as timestamp),CAST("LOGFILE_VORDEL_S"."DATE_HOUR" as timestamp))=19,23 sec
      which mean
      19 Second and 23 Millisecond.