# Historical Partition Start Time

**URL:** <https://forum.inductiveautomation.com/t/historical-partition-start-time/3020>\
**Category:** Ignition\
**Created:** [June 16, 2011, 4:02pm UTC](https://forum.inductiveautomation.com/t/historical-partition-start-time/3020 "2011-06-16T16:02:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PeterThornton](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@PeterThornton](https://forum.inductiveautomation.com/u/PeterThornton)\
**Post date:** [June 16, 2011, 4:02pm UTC](https://forum.inductiveautomation.com/t/historical-partition-start-time/3020/1 "2011-06-16T16:02:55Z")

</div>

I have set my system to a partition length of “1” and a partition unit of “Month”.  
As expected, I have one partition per month:  
sqlt\_data\_1\_2011\_04, sqlt\_data\_1\_2011\_05, sqlt\_data\_1\_2011\_06 and so on.

However, partitions don’t seem to begin until 09:14 or 10:14 on the first of the month (I think the 09:14 vs 10:14 is to do with daylight savings), and don’t end until the same time on the first of the following month.

This means that some of April’s data is in the May partition, some of May’s data is in the June partition and so on.

Is there any way to ensure that there is only data for a particular month in the partition for that month?

What determines the cutover time between partitions?

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [June 16, 2011, 5:56pm UTC](https://forum.inductiveautomation.com/t/historical-partition-start-time/3020/2 "2011-06-16T17:56:58Z")

</div>

Ah, yes, that’s an interesting observation. It looks like it’s a tiny bug that’s causing that- won’t affect performance or anything, but what’s going on is that when calculating the start time of the next month, it’s accidentially using the the current time values for hour/minute. So, the first time you started the system up was at 9am on some day. It looked to day 1 of the next month, but kept the time at 9 am.

Should be easy enough to fix for 7.2.7.

Regards,