# How do I convert MySQL TIMESTAMP to UK date/time format?

**URL:** <https://discourse.nodered.org/t/how-do-i-convert-mysql-timestamp-to-uk-date-time-format/70416>\
**Category:** General\
**Created:** [10 November 2022 22:32 UTC](https://discourse.nodered.org/t/how-do-i-convert-mysql-timestamp-to-uk-date-time-format/70416 "2022-11-10T22:32:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Richard238](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/richard238/32/48307_2.png) [@Richard238](https://discourse.nodered.org/u/Richard238)\
**Post date:** [10 November 2022 22:32 UTC](https://discourse.nodered.org/t/how-do-i-convert-mysql-timestamp-to-uk-date-time-format/70416/1 "2022-11-10T22:32:19Z")

</div>

Setup a Pi sending cpu temperature readings, stored in MySQL.

I have an SQL SELECT in a function node which is pulling in an array of objects.  
I have got the temperature out of the object and showing on a node-red dashboard.

What I cannot find how to do, is to reformat the time and date from.......

```auto
2022-11-10T22:13:03.000Z

```

....to 22:13 11/10/2022

Hope someone can help,  
Thank you.

---

<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:** [10 November 2022 22:46 UTC](https://discourse.nodered.org/t/how-do-i-convert-mysql-timestamp-to-uk-date-time-format/70416/2 "2022-11-10T22:46:17Z")

</div>

You can us the [angularjs](https://docs.angularjs.org/api/ng/filter/date#:~:text=Date%20to%20format%20either%20as,MM%2Ddd%20or%20yyyyMMddTHHmmssZ.) date format in the ui value fields  
`{{msg.payload | date : "HH:mm: dd-MM-yyyy" }}`  
e.g.

```auto
[{"id":"97f4b5a1cfbfe0f5","type":"inject","z":"452103ea51141731","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"2022-11-10T22:13:03.000Z","payloadType":"str","x":430,"y":4160,"wires":[["910bbd4af90b27c5"]]},{"id":"910bbd4af90b27c5","type":"ui_text","z":"452103ea51141731","group":"2d4fe667.28f8ba","order":18,"width":0,"height":0,"name":"","label":"text","format":"{{msg.payload | date : \"HH:mm: dd-MM-yyyy\" }}","layout":"row-spread","className":"","x":590,"y":4160,"wires":[]},{"id":"2d4fe667.28f8ba","type":"ui_group","name":"demo","tab":"1caa8458.b17814","order":2,"disp":true,"width":"12","collapse":false},{"id":"1caa8458.b17814","type":"ui_tab","name":"Demo","icon":"dashboard","order":1,"disabled":false,"hidden":false}]

```

---

<div class="post-metadata">

**Author:** ![Richard238](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/richard238/32/48307_2.png) [@Richard238](https://discourse.nodered.org/u/Richard238)\
**Post date:** [11 November 2022 09:17 UTC](https://discourse.nodered.org/t/how-do-i-convert-mysql-timestamp-to-uk-date-time-format/70416/3 "2022-11-11T09:17:03Z")

</div>

I see, so we're using our own timestamp, ignoring that from the SQL Select. Clever!  
I'll have a play later, thank you.

---

<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:** [10 January 2023 09:17 UTC](https://discourse.nodered.org/t/how-do-i-convert-mysql-timestamp-to-uk-date-time-format/70416/4 "2023-01-10T09:17:19Z")

</div>

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