How can I convert creationDate in BONITA_BPM database to normal date format?

Q&A
1

Hi,

I'm investigating production issue of our system, and I want to know the date which users were created on Bonita. However when I access the table 'user_' , I saw the creationDate being the value like 1633716036997. Is there anyway I can convert this value to date?

2

Hi,

No you cannot change the internal Bonita database schema. When retrieving users client side, the date format is a string with the following pattern yyyy-MM-dd HH:mm:ss.SSS.

HTH
Romain