1 Reply Latest reply on Aug 13, 2013 8:00 AM by jfalberg

    Trouble using Dates, Times, DateTimes in sql update statements

    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?