History Service data granularity

Camunda 7 Topics Discussion & Questions
1

Hi,

I’m using the historyService.createHistoricProcessInstanceQuery call to get historic events.
However, I’m only able to get up to seconds granularity, not milliseconds. Is seconds the most I can get?
It would be nice to get milliseconds, for many reasons.

Thanks,
Galen

2

Hi Galen,

what version of Camunda and database do you use?

Best regards,
Philipp

3

Hi Philipp,

We are using Camunda 7.7.0, and MySQL 5.5.40.

Thanks,
Galen

4

Hi Galen,

it’s because of the MySQL database. Since version 5.6.4, MySQL also supports milliseconds.
Please see the details at CAM-5183.

Best regards,
Philipp

5

Thanks! We can confirm we do see milliseconds in later versions of the database.
Thanks,
Galen

6