Hello,
I am sending 6 tags to my dB. It is important that they write to the dB at the first beginning of every minute. For example, it needs to be 05:36, not 05:36:24. How do i accomplish this?
Why?
You're going to be out by microseconds at best. If you write into a wide table the results of queries on the table will have one timestamp for all columns.
I am trying to mirror a preexisting dB. I am not worried about ms, but I would like to make it be at the beginning of every minute.
Use a run always expression item (read only) with the following:
getminute(now())
use that item to trigger the group on value change.
You schedule transaction groups instead using an interval. If you schedule per minute, it will execute close to the top of the minute. You can also use gateway Scheduled events instead of Timer events for similar functionality with scripts.
A "scheduled" transaction group would read like "Start at 00:00:00 and repeat every minute" or something like that. (Haven't used this in a while.)