History Service data granularity


#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