To correct date format in A+ Database
Find the ID for the table
select * from zdbdbobject where displayname like 'table name or column name'
Connect to psql
\AnalyticsPlus\pgsql\bin>psql.exe -h localhost -p 33366 -U postgres
\c zreportsdb
zreportsdb=# update zdbimportprops set dateformat='dd/MM/yyyy HH:mm:ss' where objid='table's id';