# Conversion influx retention 168h0m0s to msec

**URL:** <https://discourse.nodered.org/t/conversion-influx-retention-168h0m0s-to-msec/53273>\
**Category:** General\
**Created:** [5 November 2021 20:53 UTC](https://discourse.nodered.org/t/conversion-influx-retention-168h0m0s-to-msec/53273 "2021-11-05T20:53:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![henkkas](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henkkas/32/39844_2.png) [@henkkas](https://discourse.nodered.org/u/henkkas)\
**Post date:** [5 November 2021 20:53 UTC](https://discourse.nodered.org/t/conversion-influx-retention-168h0m0s-to-msec/53273/1 "2021-11-05T20:53:47Z")

</div>

It is possible to request the retention policy of an Influx database, but the result is a time format like 168h0m0s (=autogen). Is there an easy way to convert this format to milliseconds?

---

<div class="post-metadata">

**Author:** ![ghayne](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ghayne/32/39_2.png) [@ghayne](https://discourse.nodered.org/u/ghayne)\
**Post date:** [5 November 2021 21:16 UTC](https://discourse.nodered.org/t/conversion-influx-retention-168h0m0s-to-msec/53273/2 "2021-11-05T21:16:55Z")

</div>

168 \* 3600 \* 1000 = 604,800,000.

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [5 November 2021 21:32 UTC](https://discourse.nodered.org/t/conversion-influx-retention-168h0m0s-to-msec/53273/3 "2021-11-05T21:32:47Z")

</div>

some thing like this

```auto
[{"id":"9041e396.e08c28","type":"inject","z":"b779de97.b1b46","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"168h0m0s","payloadType":"str","x":220,"y":180,"wires":[["56329e1e.a1243"]]},{"id":"56329e1e.a1243","type":"change","z":"b779de97.b1b46","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"(\t$bits := $split($$.payload, /[^\\d]/, 3).$number($);\t($bits[0] * 3600000) + ($bits[1] * 60000) + ($bits[2] * 1000)\t)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":430,"y":180,"wires":[["5b7b3dbe.2f2e4c"]]},{"id":"5b7b3dbe.2f2e4c","type":"debug","z":"b779de97.b1b46","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":630,"y":100,"wires":[]}]

```

Using a change node and a JSONata expression

```auto
(
   $bits := $split($$.payload, /[^\d]/, 3).$number($);
   ($bits[0] * 3600000) + ($bits[1] * 60000) + ($bits[2] * 1000)
)

```

Similar can be done in a Function node.

---

<div class="post-metadata">

**Author:** ![henkkas](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henkkas/32/39844_2.png) [@henkkas](https://discourse.nodered.org/u/henkkas)\
**Post date:** [6 November 2021 09:46 UTC](https://discourse.nodered.org/t/conversion-influx-retention-168h0m0s-to-msec/53273/4 "2021-11-06T09:46:37Z")

</div>

@E1cid , thanks for your solution. I meant with "easy way"  
, if there was a standard function like "Date.parse(), but this will do nicely too.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [20 November 2021 09:47 UTC](https://discourse.nodered.org/t/conversion-influx-retention-168h0m0s-to-msec/53273/5 "2021-11-20T09:47:05Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.