[FIXED] How to Solve Getting Different Result of Query in MAMP MySQL Server and TablePlus MySQL Server?

Issue

I have a table and I want to run a query, first I've tried the MySQL server on MAMP and I've got this result:

After that, I imported my table into the TablePlus MySQL server, and this time I'm getting a different result.

Why the result of this query is different from the MAMP's result? How can I solve this inequality?

Solution

It's because of the timezone in tablePlus and with changing the timezone configuration I'm getting the same result:

Answered By - Haniyeh Asemi