Product and version (e.g. FileMaker Pro 14.0.3): 16.0.4
OS and version: Mac 10.13.2
Hardware: MBP 16 GB RAM, 500 GB free disk space
Description: JDBC query does not match FMP data for dates.
JDBC driver version: FMP 16 released verion.
How to replicate
Created simple FMP database with a date field:
Added two records:
Created a JDBC connection sharing.
Then, did a simple SELECT * FROM datetest from a SQL Client using the FMP JDBC driver, but the days were off by one.
The SQL query returns non-matching dates from FMP.
These non-matching JDBC dates returned appears to be a serious JDBC bug.
Workaround (if any). Nope.