FileMaker ODBC driver does not recognise fractional seconds

Discussion created by BuildsafeAustralia on Feb 26, 2018
Latest reply on Feb 28, 2018 by TSGal



I'm reporting a bug: FileMaker ODBC Driver version doesn't recognise the following SQL statement, saying there is an error in the syntax of the query:


UPDATE test SET test = {t '13:50:04.999'}


but it does accept:


UPDATE test SET test = {t '13:50:04'}


The type of the field 'test' in this example is "Time".


It should allow this, as per this link: ODBC Datetime Format


PS: It works correctly for "Timestamp" fields, just not "Time" fields.