[SOLVED] Insert problem in a Filemaker datetime field

Insert problem in a Filemaker datetime field

I need to enter a value in a Filemaker table, in a field that should be DATETIME or TIMESTAMP.I do not know Filemaker at all, but I do this simple query

INSERT INTO RadioGestInterface (Data_Ora_Prestazione) VALUES ('2019-02-14 11:13:11')

But I always get this error: ERROR [HY000] [FileMaker][FileMaker] FQL0013/(1:62): Incompatible types in assignment. Where am I wrong?

Solution

According to the FileMaker®16 SQL Reference document, page 24:

For ODBC and JDBC applications, FileMaker accepts the ODBC/JDBC format date, time, and timestamp constants in braces ({}).

Examples

{D '2019-06-05'}

{T '14:35:10'}

{TS '2019-06-05 14:35:10'}

FileMaker allows the type specifier (D, T, TS) to be in upper case or lower case. You may use any number of spaces after the type specifier, or even omit the space.

FileMaker also accepts SQL-92 syntax ISO date and time formats with no braces.

Examples

DATE 'YYYY-MM-DD'

TIME 'HH:MM:SS'

TIMESTAMP 'YYYY-MM-DD HH:MM:SS'