Date type is stored in BDM database as string/varchar?

Submitted by sujith.g_1364085 on Thu, 01/30/2020 - 07:38

We are using Bonita 7.6.1 with MySQL, and recently realised that the date fields/data are stored as character string/varchar inside the business database? How do we do date-based queries on the business database now?

Anyone has faced/solved this issue please reply.