# Variable Store to table

**URL:** <https://community.tulip.co/t/variable-store-to-table/4314>\
**Category:** Support, Troubleshooting, & Help\
**Tags:** apps\
**Created:** [January 6, 2022, 1:48pm UTC](https://community.tulip.co/t/variable-store-to-table/4314 "2022-01-06T13:48:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![h.koren](https://avatars.discourse-cdn.com/v4/letter/h/ec9cab/32.png) [@h.koren](https://community.tulip.co/u/h.koren)\
**Post date:** [January 6, 2022, 1:48pm UTC](https://community.tulip.co/t/variable-store-to-table/4314/1 "2022-01-06T13:48:15Z")

</div>

Hello,

I have a question.  
I have in a table a production start time and production complete time  
How can i get the production time? "Production complete time - Production start time.  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/f/f8f685c745fd3d7288dc71b6a8266524f3180ae2.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/f/faa513c0623dd5d5fcc6f25afd1ec0ffd3804b8c.png)

My problem is, I want to store Variable “eindtijd” in to my table

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/81f6fe22ff608c3bd8032e223d84bcc632a129de.png)

On this place

Thanks Henk

---

<div class="post-metadata">

**Author:** ![Pete\_Hartnett](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/pete_hartnett/32/3678_2.png) [@Pete\_Hartnett](https://community.tulip.co/u/Pete_Hartnett)\
**Post date:** [January 6, 2022, 2:47pm UTC](https://community.tulip.co/t/variable-store-to-table/4314/2 "2022-01-06T14:47:56Z")

</div>

Hey Henk,

Good to see you back!

This is a simple one - So your column in the table is type ‘Datetime’ and it needs to be type ‘Interval’. Intervals are chunks of time, versus datetimes which are representations of a single time on an actual day. When you take one date (say yesterday at noon) and look at distance to another time (right now), you will get an interval (17 hours).

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/a/a68783d48bfaee1269e01c04b8079cd3405693d2.jpeg)

You can’t change the column type of a table column after it is created, but you can delete the datetime column you created and recreate it as a interval.

Does this make sense?  
Pete

---

<div class="post-metadata">

**Author:** ![h.koren](https://avatars.discourse-cdn.com/v4/letter/h/ec9cab/32.png) [@h.koren](https://community.tulip.co/u/h.koren)\
**Post date:** [January 6, 2022, 3:04pm UTC](https://community.tulip.co/t/variable-store-to-table/4314/3 "2022-01-06T15:04:11Z")

</div>

Hello Pete.

I first created a column in my table with time and date and that doesn’t work! I tried later an interval and it works! 🙂

Thanks!!! Have I nice day

![image001.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/873363b917a251ec31b8e23086aa3c1e1ffa1b70.png)