Date format wrongly set in A+ DB

Date format wrongly set in A+ DB

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';

                  New to ADSelfService Plus?