SqlServer Date Type BDM

system · 1 October 2020 16:30

Hello,

one friend of mine created a Business Object with attribute of type "Date Only".

He deployed it on Bonita wildfly bundle 7.8.4 connected to Sqlserver

The related table has the attribute of type nvarchar.

Is it normal?

Thanks in advance,

romain.bioteau · 3 October 2020 08:36

Hi,
Yes, dates format are serialized in the database using the ISO-8601 string format.

HTH
Romain

Topic		Replies	Views
Date type is stored in BDM database as string/varchar? Q&A	0	1	30 January 2020
Insert Date in to SQL Server 2008 Table Q&A	5	0	9 December 2014
How to manage dates and time in BDM and user interfaces Blog	0	2	15 December 2020
Doing a query on a BDM custom that has a date Q&A	1	1	7 March 2022
How can I convert creationDate in BONITA_BPM database to normal date format? Q&A	1	1	19 October 2021