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?
Related Articles
Procedure to upload local DB to Analytics Plus
Steps to use Upload Tool for uploading Data from any DB: 1. Download and extract the uploadtool.zip from this link 2. Configure the Database connection details: Open the file 'database_connection_params.conf' located under <Uploadtool>\conf\ folder, ...Steps to import approval date
We can fetch the approval date data from ServiceDesk Plus using the following workaround. Below are the steps to be followed to successfully import the data. Step 1: Click Import data within the ServiceDesk Plus database in Analytics Plus. Step 2: ...TRUNCATEADD not deleting existing rows in DB import
Issue: when 0 records are imported with 'delete and add records' chosen, the old entries in Analytics table is not getting removed. (DB import) Builds identified: 4300, 4310, 4350 Description: The problem with the table not removing the old entries ...How to add/view current date in a dashboard
1. Click on "Edit Design" in a dashboard 2. Choose Add Text and select edit HTML( refer attached screenshot) 3. Watch this video to see how you can do it. Video link: https://youtu.be/hcaTPUuM9PE Clock ...The date for any columns is set to 01 Jan 1970 01:00:00.000000
Issue: The date columns are filled with 01 Jan 1970 01:00:00.000000 instead of being empty. Root Cause: ServiceDesk Upgrade did not handle it Solution: Add the entry " ZOHO_UPDATE_NULL_FOR_NEGATIVEVALUE=true" in ...
