# Is there a way to have timezoned day partitions? **URL:** \ **Category:** Community\ **Tags:** question\ **Created:** [June 18, 2025, 11:31am UTC](https://community.questdb.com/t/is-there-a-way-to-have-timezoned-day-partitions/870 "2025-06-18T11:31:29Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![SJC](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/sjc/32/438_2.png) [@SJC](https://community.questdb.com/u/SJC)\ **Post date:** [June 18, 2025, 11:31am UTC](https://community.questdb.com/t/is-there-a-way-to-have-timezoned-day-partitions/870/1 "2025-06-18T11:31:29Z")
Hi, I am currently developing an app that handles iot data in a local facility. I have tables that store iot data that is partitioned by day. The partition is kept for a month and expired partitions are dropped by our scheduled worker. I am trying to delete only the data that are ruled expired under the local timezone, which is “Asia/Seoul”, but since the table partitions follow UTC timezone, dropping partition ‘2025-05-18’ means dropping data from ‘2025-05-18 09:00:00 KST’ to ‘2025-05-19 08:59:59 KST’. Is there a way to configure the partitions to be timezoned? Or if there are any suggestions for a workaround, I would greatly appreciate it. Thanks. ---
**Author:** ![nwoolmer](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/nwoolmer/32/24_2.png) [@nwoolmer](https://community.questdb.com/u/nwoolmer)\ **Post date:** [June 18, 2025, 2:24pm UTC](https://community.questdb.com/t/is-there-a-way-to-have-timezoned-day-partitions/870/2 "2025-06-18T14:24:06Z")
Hi @SJC , Unfortunately not. It will be possible if you partition by hour, and then offset your drop range by 9 hours. Otherwise, you can just hold a couple of extra days and delete them later on. Then just make sure your queries are bounded by Seoul time, so you don’t return this extra data.