MySQL database showing wrong timestamp

Hi guys, Im trying to make website here. In phpmyadmin i have column for date-time values. It is putting timestamp around +05:00 UTC. How do I change it?

Thanks.

You can use PHP functions to set the timezone for the current session. You can’t change the server timezone.

4 Likes

Where and how should i change it please?

The first step is to update your code to NEVER let MySQL generate times for you. Don’t use CURRENT_TIMESTAMP() or NOW(). If you need to current time, always generate it through PHP.

You can set the timezone for PHP through the PHP Options menus in the client area or control panel.

3 Likes

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