# Node-red-node-mysql date +8 hour

**URL:** <https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901>\
**Category:** General\
**Created:** [13 May 2024 01:48 UTC](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901 "2024-05-13T01:48:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![HenryTrang](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henrytrang/32/81582_2.png) [@HenryTrang](https://discourse.nodered.org/u/HenryTrang)\
**Post date:** [13 May 2024 01:48 UTC](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901/1 "2024-05-13T01:48:17Z")

</div>

node-red-node-mysql date +8 hour invalid. anyone know how to fixed it?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/3/b3c203eb9bf815cc1702ed1af927618ae7594afd.png)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [13 May 2024 16:38 UTC](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901/2 "2024-05-13T16:38:18Z")

</div>

Where exactly are you seeing the error? Show us a screenshot or copy/paste log info if that is where it is.

---

<div class="post-metadata">

**Author:** ![HenryTrang](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henrytrang/32/81582_2.png) [@HenryTrang](https://discourse.nodered.org/u/HenryTrang)\
**Post date:** [15 May 2024 07:18 UTC](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901/3 "2024-05-15T07:18:31Z")

</div>

in database. the date alway 8hours behind.

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [15 May 2024 07:36 UTC](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901/4 "2024-05-15T07:36:15Z")

</div>

Fujian uses China Standard Time I believe. That's UTC +8.

So it sounds like your database is storing times as UTC and I think that is best practice.

If you remove that timezone setting in the config, does Node-red show times correctly?

---

<div class="post-metadata">

**Author:** ![HenryTrang](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henrytrang/32/81582_2.png) [@HenryTrang](https://discourse.nodered.org/u/HenryTrang)\
**Post date:** [27 May 2024 09:11 UTC](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901/5 "2024-05-27T09:11:34Z")

</div>

thank you dude. it is cache, working correctly now. thank you anyway.

---

<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 June 2024 09:12 UTC](https://discourse.nodered.org/t/node-red-node-mysql-date-8-hour/87901/6 "2024-06-10T09:12:27Z")

</div>

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