How ist the duration calculated in History tables?

[nikki]

Hello together,
I try to analyse the history data of process instances. How is the duration calculated in history tables? If I calculate a duration by deducting End_Time and Start_Time I come to other results, than in history service. So do I have a format problem?
Thanks for your help!
greets Nikki

[frederikherema1]

Duration (in millis) is calculated based in start and end-time (HistoricScopeInstanceEntity):

public void markEnded(String deleteReason) {
    this.deleteReason = deleteReason;
    this.endTime = ClockUtil.getCurrentTime();
    this.durationInMillis = endTime.getTime() - startTime.getTime();
  }

Are you using MySQL? The timestamp type is only accurate to the second, milliseconds can differ from the actual value used for calculation.

[nikki]

Thanks for your help!