# In sqlth\_partitions, start \_time does not start on the first day of the month **URL:** \ **Category:** Ignition\ **Created:** [May 17, 2019, 9:58am UTC](https://forum.inductiveautomation.com/t/in-sqlth-partitions-start-time-does-not-start-on-the-first-day-of-the-month/25095 "2019-05-17T09:58:20Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![nagewaza1009](https://avatars.discourse-cdn.com/v4/letter/n/838e76/32.png) [@nagewaza1009](https://forum.inductiveautomation.com/u/nagewaza1009)\ **Post date:** [May 17, 2019, 9:58am UTC](https://forum.inductiveautomation.com/t/in-sqlth-partitions-start-time-does-not-start-on-the-first-day-of-the-month/25095/1 "2019-05-17T09:58:20Z")
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, ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 17, 2019, 12:07pm UTC](https://forum.inductiveautomation.com/t/in-sqlth-partitions-start-time-does-not-start-on-the-first-day-of-the-month/25095/2 "2019-05-17T12:07:23Z")
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.