# UTC\_Timestamp different from System Time

**URL:** <https://forum.mautic.org/t/utc-timestamp-different-from-system-time/23326>\
**Category:** Product Support\
**Created:** [March 28, 2022, 1:32pm UTC](https://forum.mautic.org/t/utc-timestamp-different-from-system-time/23326 "2022-03-28T13:32:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [March 28, 2022, 1:32pm UTC](https://forum.mautic.org/t/utc-timestamp-different-from-system-time/23326/1 "2022-03-28T13:32:07Z")

</div>

I noticed that when Mautic writes to the database it uses UTC\_Timestamp and not system time.  
What this does is write the time/date differently from both mysql now() time and system time.

Example:  
This campaign has three events scheduled:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/d/dcc87ea9bea831e2312710fbb1fb75e93c560864.png)

Inside the DB it is written that the campaigns are scheduled at 12:40, 13:40 and two days later at at 12.  
However inside the campaign it is set to 3 hours later.

Inside mysql this is the output I see and it looks like UTC\_Timestamp is the culprit  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/6/611046854e9929033c5c9067f21fd391228c9869.png)

This does not break any campaign and things still go out at the correct hour, however when doing direct queries on the database for internal scripting etc… we are getting false information.

Does anyone have any clue on how to fix this ?

---

<div class="post-metadata">

**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\
**Post date:** [March 28, 2022, 2:06pm UTC](https://forum.mautic.org/t/utc-timestamp-different-from-system-time/23326/2 "2022-03-28T14:06:59Z")

</div>

Hi,

mautic (or any app really) should store date and time in utc because otherwise it complicates things when you try to represent the same data to the users worldwide.

When using the scripts read the timezone info from app/config/local.php - key default\_timezone and calculate the “valid” time based on the offsets.

---

<div class="post-metadata">

**Author:** ![edisonkrs](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/edisonkrs/32/14205_2.png) [@edisonkrs](https://forum.mautic.org/u/edisonkrs)\
**Post date:** [October 14, 2025, 8:30pm UTC](https://forum.mautic.org/t/utc-timestamp-different-from-system-time/23326/3 "2025-10-14T20:30:17Z")

</div>

Hi,

I have Mautic installed with Docker and had this timezone issue where dates saved as UTC instead of local time.

My question: Does this work the same way on a dedicated server?

Thanks,