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

**URL:** <https://community.ofelia.com/t/date-type-is-stored-in-bdm-database-as-string-varchar/9983>\
**Category:** Q&A\
**Created:** [30 January 2020 06:38 UTC](https://community.ofelia.com/t/date-type-is-stored-in-bdm-database-as-string-varchar/9983 "2020-01-30T06:38:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sujith.g\_1364085](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@sujith.g\_1364085](https://community.ofelia.com/u/sujith.g_1364085)\
**Post date:** [30 January 2020 06:38 UTC](https://community.ofelia.com/t/date-type-is-stored-in-bdm-database-as-string-varchar/9983/1 "2020-01-30T06:38:34Z")

</div>

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&nbsp;now?&nbsp;

Anyone has faced/solved this issue please reply.

&nbsp;