1 Reply Latest reply on Aug 13, 2013 10:53 AM by jfalberg

    Timestamp trouble in SQL

    jfalberg

      Title

      Timestamp trouble in SQL

      Post

           I'm not sure I understand what is wrong with this SQL statement:

           Update Users set "Logdate" = {TS '2013-08-13 13:42:22'} where LOWER("UserName") = 'jeff'

           I get the following error message:

           ERROR [42000] [FileMaker][FileMaker] FQL0010/(1:39): The literal value "2013-08-13 13:42:22" is not a valid DATE, TIME or TIMESTAMP.