Also, is the database on a different server? How are you getting the time for the trigger? It could be a difference between the clocks of the FactorySQL machine, and the database server. The query that FactorySQL sends to the server will have “t_stamp=CURRENT_TIMESTAMP”, so the time recorded will be the database time. If you’re getting the trigger time with an expression and “now()” (or one of the other similar functions), you’re using the time on the local machine.
If this sounds like your setup, I would recommend logging the local machine time as the timestamp. You can do this easily:
- On the group, turn off “store timestamp”
- Create an Action Item, set it to “DateTime” datatype, writeback to “t_stamp”, and set its expression to “now()”.
Regards,