You can translate the question and the replies:

empty dates in MySQL problem

I'm connect Denodo to a MySQL server. I have a table with datatime columns. Some of the values are empty, thich look like '0000-00-00'. These are not null values, these are empty values. It appears Denodo cannot handle these values and reports an error. Is there a way to configure denodo to handle empty dates in MySQL property?
user
25-10-2016 19:03:18 -0400

1 Answer

Hi! MySQL allows you to modify how dates are returned to the applications in those cases. For your scenario, in order to return the correct values when the dates are empty you just need to include ?zeroDateTimeBehavior=convertToNull in your data source url so it looks something like: jdbc:mysql://localhost:3306/?zeroDateTimeBehavior=convertToNull More information about this property can be found in [MySQL documentation](https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html) Hope it helps!!
Denodo Team
28-10-2016 19:21:22 -0400
You must sign in to add an answer. If you do not have an account, you can register here