BuildsafeAustralia

FileMaker ODBC driver does not recognise fractional seconds

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


Hi,

 

I'm reporting a bug: FileMaker ODBC Driver version 15.0.6.0 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.

Outcomes