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
19 Second and 23 Millisecond.