In sqlth_partitions, start _time does not start on the first day of the month

Ignition
1

Hello everyone,

I recently realized while looking at the Tag History Tables that the tables sqlt_data_x_x_x does not start on the first day of the month at 00:00:00 AM but on the last day of the previous month at 10:00:00 PM or 11:00:00 PM.

I am in France, could this be linked to a Timezone ?

Anyway, i would like to change them to actual first (and last) day of the month. The problem if i change them manually in the table sqlth_partitions (apart from the danger of disorganizing completely the database) is that i don’t know if the database will carry on with the correction for the new Tag data tables or not.

Has anyone dealt with such a problem before ?

Thank you in advance,

2

The change is based on UTC. You really should be using Ignition’s Tag History bindings and/or scripting functions to retrieve data from the history system.