# Formatting Category Label

**URL:** <https://forum.inductiveautomation.com/t/formatting-category-label/7000>\
**Category:** Ignition\
**Created:** [August 7, 2013, 9:45pm UTC](https://forum.inductiveautomation.com/t/formatting-category-label/7000 "2013-08-07T21:45:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Micky.Franks](https://avatars.discourse-cdn.com/v4/letter/m/c57346/32.png) [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\
**Post date:** [August 7, 2013, 9:45pm UTC](https://forum.inductiveautomation.com/t/formatting-category-label/7000/1 "2013-08-07T21:45:33Z")

</div>

Is there any way to format the category label on a chart besides through query functions. I am using SQL express and the closest format I can get is HH:mm:ss. Would like to strip it down to HH am/PM.

[attachment=0]Chart.png[/attachment]

---

<div class="post-metadata">

**Author:** ![Micky.Franks](https://avatars.discourse-cdn.com/v4/letter/m/c57346/32.png) [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\
**Post date:** [August 12, 2013, 8:24pm UTC](https://forum.inductiveautomation.com/t/formatting-category-label/7000/2 "2013-08-12T20:24:14Z")

</div>

Found a way to do it through my SQL query.

```auto
select RIGHT(CONVERT(VARCHAR(26), logdatetime, 100), 7)
```