Good friends, I have a problem parsing some information from a table that I need to make a comparison and that way it returns a string value, the fact is that it gives me an error: <title> Error 500 com.mysql.cj. exceptions.DataReadException: Zero date value prohibited </title> since that table actually has fields with dates at 0, is there any way to fix this in some way ????
Good friends, I have a problem parsing some information from a table that I need to make a comparison and that way it returns a string value, the fact is that it gives me an error: <title> Error 500 com.mysql.cj. exceptions.DataReadException: Zero date value prohibited </title> since that table actually has fields with dates at 0, is there any way to fix this in some way ????
Hello there, I need to create a SQL command that validates a DATE field with value 0000-00-00 in the file "config.properties" of the jRDC2 server I have already tried in different ways: a) sql.select_ctacte_saldo_clie=Select Sum(SALDO) as SALDO From CLIENTE Where FECHAEGRE='0000-00-00' b)...