Assistance required to insert null values into a PostgreSQL database instead of the default 1900 value used by OutSystems.
PostgreSQL version-PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
Hi @Santhosh Kumar HU,
In the Integration Studio, you set the Default Value behavior to "Convert to/from NULL value in Database. This will allow you to save null value to your PostgreSQL.
Hi Santhosh,
on the insert statement, on the value side write null, be on the table side that column must accept null values, if not then the default date will be applied.
Regards and hope that this could help you.
Hi Carl, We are using outsystems provided entity actions not insert statements.
Thank you all, Its started working after changing this configuration which Kiet Phan shared.