ADDDATE for the JDBC driver unexpectedly returns null [BUG]

[ghost]

Describe the bug
ADDDATE function for the JDBC driver returns null for all values while the SQL Plugin returns non-null values

To Reproduce
Steps to reproduce the behavior:

1. Load the calcs table on to the server
2. Run a query with ADDDATE to the SQL Plugin for example curl -XPOST http://localhost:9200/_plugins/_sql -u admin:admin --insecure -H 'Content-Type: application/json' -d '{"query": "SELECT adddate(date(calcs.datetime0), INTERVAL 1 day) FROM calcs GROUP BY 1"}' for Windows Subsystem for Linux
3. Run the same query using a tool like DBVisualizer to test the query on the JDBC driver.

Expected behavior
The expected behaviour should be values that match the output of the SQL Plugin. For example, the output for the query above is

Actual behavior
The output from the JDBC driver are all null.

Host/Environment:

• OS: Windows 10
• Version 21H1