# Time format in Data time series node

**URL:** <https://forums.losant.com/t/time-format-in-data-time-series-node/2067>\
**Category:** Help\
**Tags:** workflow\
**Created:** [August 8, 2019, 9:41pm UTC](https://forums.losant.com/t/time-format-in-data-time-series-node/2067 "2019-08-08T21:41:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\
**Post date:** [August 8, 2019, 9:41pm UTC](https://forums.losant.com/t/time-format-in-data-time-series-node/2067/1 "2019-08-08T21:41:12Z")

</div>

When using time series node and aggregation Mean, the time value is a unix timestamp, but when using Sum, it a character string.  
Is there a reason for that?  
If not how do best format the time value in preparation for a CSV encode node?

---

<div class="post-metadata">

**Author:** ![anaptfox](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/anaptfox/32/873_2.png) [@anaptfox](https://forums.losant.com/u/anaptfox)\
**Post date:** [August 8, 2019, 10:23pm UTC](https://forums.losant.com/t/time-format-in-data-time-series-node/2067/2 "2019-08-08T22:23:09Z")

</div>

@Lars_Andersson,

Can you provide some screenshots of what you’re seeing? As always, the more information you can provide the better.

---

<div class="post-metadata">

**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\
**Post date:** [August 8, 2019, 10:50pm UTC](https://forums.losant.com/t/time-format-in-data-time-series-node/2067/3 "2019-08-08T22:50:15Z")

</div>

I misspoke. It’s when I run the payload through the CSV encode node that the date-time string gets converted to a unix time stamp. (Changing from mean to sum was not the problem)  
before:  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/5/5ea4cac29a6162548764d8a4c07962add4f1af17.png)  
after:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/6/68be56d1206491bf08d134d19506e80ebe6830ca.png)  
how would I best be able to keep the string format?

---

<div class="post-metadata">

**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\
**Post date:** [August 9, 2019, 12:17pm UTC](https://forums.losant.com/t/time-format-in-data-time-series-node/2067/4 "2019-08-09T12:17:08Z")

</div>

Do I need to convert the time to a string before using the CSV Encode Node?