MarkTasker

Hi Dan, Thank you for getting back to me. The polling interval is set as follows: However, the data timestamp is postgres is always 1 hour behind current time. I'd...

!-- Polling rate, in seconds -- PollInterval value="60"

Could it be due to BST?

It appears to be the calculation: DATETIME(INT((FLOAT([Timestamp]))*(1440/[Minute Interval]))/(1440/[Minute Interval])) if you try DATETIME(INT((FLOAT(Now()))) you get the hour difference when comparing to now() Not sure if I am using the latest...

To get around the lost hour I am just adding it back in to the rounded timestamp equation: DATETIME(INT((FLOAT([Timestamp])+(1/24))*(1440/[Minute Interval]))/(1440/[Minute Interval]))