# Change historian data

**URL:** <https://forum.inductiveautomation.com/t/change-historian-data/33119>\
**Category:** Ignition\
**Created:** [March 16, 2020, 1:19pm UTC](https://forum.inductiveautomation.com/t/change-historian-data/33119 "2020-03-16T13:19:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![roinisan](https://avatars.discourse-cdn.com/v4/letter/r/65b543/32.png) [@roinisan](https://forum.inductiveautomation.com/u/roinisan)\
**Post date:** [March 16, 2020, 1:19pm UTC](https://forum.inductiveautomation.com/t/change-historian-data/33119/1 "2020-03-16T13:19:45Z")

</div>

Hello,  
I wish to know if it is possible to change tag historian data,  
for instance, I have a power table which uses tag historian query,  
and I want to modify the values,  
I tried to use the [system.tag.storeTagHistory](https://docs.inductiveautomation.com/display/DOC79/system.tag.storeTagHistory), but with no success.

could you help please?

 ![312](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/10ce40376c7525fc32373a0ac5c09c01a65a5fc1.png)

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [March 16, 2020, 1:23pm UTC](https://forum.inductiveautomation.com/t/change-historian-data/33119/2 "2020-03-16T13:23:22Z")

</div>

are you trying to change a single value or add additional entries? you should be able to change a value in the database with no issue using sql.

---

<div class="post-metadata">

**Author:** ![roinisan](https://avatars.discourse-cdn.com/v4/letter/r/65b543/32.png) [@roinisan](https://forum.inductiveautomation.com/u/roinisan)\
**Post date:** [March 16, 2020, 2:18pm UTC](https://forum.inductiveautomation.com/t/change-historian-data/33119/3 "2020-03-16T14:18:49Z")

</div>

but what if I query by interval of time, so thats there is no record in the sql with exactly the timestamp,  
how can I know what is the right record