Support Article
Date property is exposed as VARCHAR2 data type in the database
SA-8755
Summary
When you expose a property of type "Date" to a database table column, Pega creates the database table column as a VARCHAR2 data type. You want to know the reason for this behavior.
Error Messages
Not Applicable
Steps to Reproduce
- Create a property of type "Date".
- Expose the property.
- Observe the data type of the database table's newly-created column.
Root Cause
The behavior is correct.
Resolution
Please see https://pdn.pega.com/pegarules-database/date-properties-are-mapped-as-varchar2-columns-not-date-columns-on-oracle.
Published June 12, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.