fmpdude

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.

Outcomes