Problem importing date field from mysql from upload tool (Zoho Reports)
I have several date fields in MySql (stored as BIGINT) as time in milliseconds. When I try to upload these tables using the upload tool, I see the date fields get stored as 0s in the Zoho tables and I see corresponding errors in the log file saying that the date fields are invalid. However, when I look at the intermediary csv files created by the upload tool, I do see that the date columns have the right value. Further, I can manually upload these csv files through Zoho reports and the date field values are preserved.
I should add that I created the tables apriori in Zoho reports and have set the columns to be date fields with the right date format (MILLI).
Unfortunately, I don't control the database and making changes to that is out of the question. Is there any configuration setting in Zoho reports or the upload tool that'll help me fix this.