We have a sale form with date picker that output unix timestamp.
We convert to Date String like this
DATESTR( documentdate , "YYYY-MM-DD")
Therefore, we get e.g 2021-10-14
In Mysql Query Builder, we test with sample date string parameter, query is able to insert data in mysql database.
But in mysql connector, it is not working to insert sale data.
Even date string parameter is there, it keep saying
Incorrect datetime value: '' for column 'documentDate' at row 1
Please guide us how can we save datetime in mysql