# Displaying 6 digit DINT tag value as HH:MM:SS

**URL:** <https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417>\
**Category:** Ignition\
**Created:** [August 24, 2022, 8:05pm UTC](https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417 "2022-08-24T20:05:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joseph\_Puente](https://avatars.discourse-cdn.com/v4/letter/j/aca169/32.png) [@Joseph\_Puente](https://forum.inductiveautomation.com/u/Joseph_Puente)\
**Post date:** [August 24, 2022, 8:05pm UTC](https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417/1 "2022-08-24T20:05:45Z")

</div>

I have a tag that displays time as HHMMSS. How can i display this 6 digit number as a time, i.e. 14:22:35. I’m not sure its even possible but I thought I would ask. Thanks!

---

<div class="post-metadata">

**Author:** ![Joseph\_Puente](https://avatars.discourse-cdn.com/v4/letter/j/aca169/32.png) [@Joseph\_Puente](https://forum.inductiveautomation.com/u/Joseph_Puente)\
**Post date:** [August 24, 2022, 8:06pm UTC](https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417/2 "2022-08-24T20:06:44Z")

</div>

I want to do the same with a tag that has an 8 digit vale for YYYYMMDD for the date.

---

<div class="post-metadata">

**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\
**Post date:** [August 24, 2022, 8:09pm UTC](https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417/3 "2022-08-24T20:09:50Z")

</div>

I’m not 100% but I think this is what you are looking for [Transforms - Ignition User Manual 8.0 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC80/Transforms)

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [August 24, 2022, 8:27pm UTC](https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417/4 "2022-08-24T20:27:56Z")

</div>

Perspective or Vision?

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [August 25, 2022, 12:47am UTC](https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417/5 "2022-08-25T00:47:58Z")

</div>

An expression tag with this expression in it does the desired formatting. Update “timestamp” tag reference in it to match your integer tag path.

```python
dateFormat(
	setTime(
		now(),
		floor({[.]timestamp}/10000),
		floor({[.]timestamp}%10000/100),
		{[.]timestamp}%100
	),
	"HH:mm:ss"
)

```

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/2/32a5a5b917b56b6c16c7e2687b3352ca6fce2ebe.png)

For date stamp, use expression below. We subtract one from the month as [getDate](https://docs.inductiveautomation.com/display/DOC81/getDate) function numbers months 0-11 instead of 1-12. We don’t need to use floor here assuming month and day numbers are never high enough to round up into larger units (unlike minutes and seconds in timestamp).

```python
dateFormat(
	getDate(
		{[.]datestamp}/10000,
		{[.]datestamp}%10000/100 - 1,
		{[.]datestamp}%100
	),
	"yyyy-MM-dd"
)

```

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/5/0591b885e687e3c4e8e3aff57d57c4b9176ed9db.png)

Both examples are taking integers and breaking them into components of a date/time, using them to set date/time, and then formatting the date/time per format string in quotes in second last line of expressions. You can change the format string to get different results.

The examples above are done in expression tags, but you could do the same conversions in component expression bindings (Vision), or binding transforms (Perspective).

---

<div class="post-metadata">

**Author:** ![Joseph\_Puente](https://avatars.discourse-cdn.com/v4/letter/j/aca169/32.png) [@Joseph\_Puente](https://forum.inductiveautomation.com/u/Joseph_Puente)\
**Post date:** [August 25, 2022, 12:33pm UTC](https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417/6 "2022-08-25T12:33:38Z")

</div>

vision

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 25, 2022, 12:37pm UTC](https://forum.inductiveautomation.com/t/displaying-6-digit-dint-tag-value-as-hhss/63417/7 "2022-08-25T12:37:01Z")

</div>

Use the modulo and division operations @witman shows, but format with `stringFormat("%02d:%02d:%02d", ...)`.