I have a JDBC INSERT INTO statement that uses the syntax given in the FileMaker SQL reference: TIMESTAMP '2019-06-05 14:35:10' . This INSERT statement works fine using this modern format. But the problem is that once this data is in FileMaker if I try to change any value, I get an error that the va…

Hi @OliverBarrett I just did some tests too: If you as @mipiano suggested change the format to TIMESTAMP '2023+08+02 20:42:00' and put a autoenter-calc GetAsTimestamp ( Self ) on the timestamp-field, the field content gets changed to the file's format. It does not work with TIMESTAMP '2023-08-02 2…

"Helped" -> Solved it! :slight_smile:

Problem: Timestamp in JDBC vs In FileMaker Itself

Questions

OliverBarrett August 3, 2023, 7:06pm 22

"Helped" -> Solved it!

Topic		Replies	Views
ISO To American Lounge (Discussions) community	4	758	February 12, 2020
FileMaker not accepting ISO 8601 compliant manual date entry Questions ux-ui	3	297	January 18, 2022
Partially Valid Dates Questions	9	694	September 13, 2021
Error Value? Questions filemaker	11	330	August 27, 2023
ExecuteSQL function not returning expected results Questions sql	7	823	February 11, 2020

Problem: Timestamp in JDBC vs In FileMaker Itself

Related topics