# System wide 24 hour clock?

**URL:** <https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169>\
**Category:** Ignition\
**Created:** [November 17, 2021, 7:41am UTC](https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169 "2021-11-17T07:41:44Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![SKA](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ska/32/29528_2.png) [@SKA](https://forum.inductiveautomation.com/u/SKA)\
**Post date:** [November 17, 2021, 7:41am UTC](https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169/1 "2021-11-17T07:41:44Z")

</div>

IS there a way to get ignition to use 24 hour clock that most of the world uses?  
I have a date time returned from a mysql database as 24 hour time, but ignition converts it to the ackward 12 hour clock in the power table.

EDIT: also, have it not put “month date, year, hh:mm”, most of the world dont have month first…

The actual result is returned as:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/2/62252fdcc1d8f128911d551d9327f8aad757c298.png)

---

<div class="post-metadata">

**Author:** ![DavidWisely](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/davidwisely/32/10482_2.png) [@DavidWisely](https://forum.inductiveautomation.com/u/DavidWisely)\
**Post date:** [November 17, 2021, 9:08am UTC](https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169/2 "2021-11-17T09:08:40Z")

</div>

I don’t know of any global way to change this, but you can specify the date format in most components. What component are you trying to display it on?

---

<div class="post-metadata">

**Author:** ![SKA](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ska/32/29528_2.png) [@SKA](https://forum.inductiveautomation.com/u/SKA)\
**Post date:** [November 17, 2021, 9:16am UTC](https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169/3 "2021-11-17T09:16:03Z")

</div>

power table, using an sql statement to get the data.

---

<div class="post-metadata">

**Author:** ![SKA](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ska/32/29528_2.png) [@SKA](https://forum.inductiveautomation.com/u/SKA)\
**Post date:** [November 17, 2021, 9:52am UTC](https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169/4 "2021-11-17T09:52:37Z")

</div>

Also, same goes for the Date Range component, shows american style dates and not what i want.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [November 17, 2021, 12:35pm UTC](https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169/5 "2021-11-17T12:35:24Z")

</div>

Check your locale:

> [@Date Range 'Auto' date style](https://forum.inductiveautomation.com/t/date-range-auto-date-style/24669):
>
> What exactly does the ‘Auto’ Date Style mean? I live in Australia where we write the date as DD/MM/YYYY or YYYY/MM/DD, and have my Windows datetime format set as such, however the ‘Auto’ option in Ignition components for the date style seems to always use the American format (MM/DD/YYYY)? It’s a bit annoying having to change this all the time, but I’m also interested in how I would develop an application for use in multiple countries and have the date format use the localised OS format, if Auto…

---

<div class="post-metadata">

**Author:** ![SKA](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ska/32/29528_2.png) [@SKA](https://forum.inductiveautomation.com/u/SKA)\
**Post date:** [November 17, 2021, 12:40pm UTC](https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169/6 "2021-11-17T12:40:54Z")

</div>

> [@JordanCClark](#):
>
> Check your locale:

My locate states the date should be written like this:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/d/8d88a8c2d8ad8f77c05a99b9e275bea2db982376.png)

---

<div class="post-metadata">

**Author:** ![SKA](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ska/32/29528_2.png) [@SKA](https://forum.inductiveautomation.com/u/SKA)\
**Post date:** [November 17, 2021, 2:00pm UTC](https://forum.inductiveautomation.com/t/system-wide-24-hour-clock/53169/7 "2021-11-17T14:00:29Z")

</div>

I did it like this in my SQL selection:

```auto
SELECT CONVERT(from_unixtime(sqlt_data_1_2021_11.t_stamp/1000),CHAR(30)) AS "Date", 

```

Now its converted to date time and then converted to a text/char where ignition shows as i want

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