Apparent JDBC Issue with Dates

Discussion created by fmpdude on Feb 8, 2018
Latest reply on Feb 17, 2018 by FileKraft

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.