AnsweredAssumed Answered

Timestamp trouble in SQL

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


Timestamp trouble in SQL


     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.