Timezones

[Hiamcyte]

What is the time zone of the ph myadmin and the hosting servers them itselves? all my dates are have been messed up!

[KangJL]

More info here

How can I get timestamp value in MariaDB/MySQL?

The issue is very much timezone related. Our servers are working correctly, but the UNIX_TIMESTAMP function works differently than you think it does. You need to realize that our servers are configured to be in the EST (UTC-5) timezone (historic reasons). The UTC_TIMESTAMP() function returns a date and time. But as you can see, it does NOT include a timezone identifier. But Unix timestamps are always in UTC, but other dates and times may not be. So the UNIX_TIMESTAMP() function converts the ti…

[dan3008]

If you’re working with times and dates in your database (And they arn’t just being used as a unique reference) I recommend using normal PHP commands to get the date and time, and adding them as a string (or a manual date\time)

You can change your PHP timezone in the PHP settings:

[Admin]

Our database servers are in the EST timezone. There is no way to configure that for individual users or databases, so that’s something you’ll just have to deal with.

PHP code also runs in the EST timezone by default. However, you can change that through the client area.