AnsweredAssumed Answered

Trouble using Dates, Times, DateTimes in sql update statements

Question asked by jfalberg on Aug 13, 2013
Latest reply on Aug 13, 2013 by jfalberg

Title

Trouble using Dates, Times, DateTimes in sql update statements

Post

     I'm trying to programmatically use an SQL update statement (haven't tried insert yet) which involves dates and timestamp fields, but have gotten as far as using this update example:

     Update ETickets set PersonBirthDate = {D '1988-11-12'} where ID = 76;

     only to get the following error message:

     ERROR [42000] [FileMaker][FileMaker] FQL0001/(1:70): There is an error in the syntax of the query.

     Is there a correct way of handling such date and timestamp fields and whether it's any different for insert statements as well?

Outcomes