AnsweredAssumed Answered

Timestamp trouble in SQL

Question asked by jfalberg on Aug 13, 2013
Latest reply on Aug 13, 2013 by 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.

Outcomes