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

Submitted by voraprotp on Tue, 10/19/2021 - 06:37
1
0
-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?

#Date
1 answer

Submitted by romain.bioteau on Tue, 10/19/2021 - 09:06
1
0
-1

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

Notifications