I have a problem in DateTime sql

[Dirbal]

When I add a new row with the current time, the time is added 7 hours late
Is there a solution to this problem

[YT_Xaos]

Welcome to the forum!

MySQL uses UTC to store the DateTime. If you live in another timezone, it will be different.

[Dirbal]

@YT_Xaos

ySQL uses UTC to store the DateTime. If you live in another timezone, it will be differe

i’m in Libya, can i fix this?

[YT_Xaos]

Instead of using CURRENT_TIMESTAMP(), you can submit data to the database using PHP or Javascript. This post explains it better than I do:

How to store a datetime in MySQL with timezone info

But instead of storing the local time, you can convert the UTC to local time as described in this other StackOverflow post:

Convert UTC dates to local time in PHP

[Dirbal]

$dt = new DateTime(‘now’, new DateTimeZone(‘UTC’));

$dt->setTimezone(new DateTimeZone(‘Africa/Tripoli’));

$formattedDateTime = $dt->format(‘Y-m-d H:i:s T’);

echo $formattedDateTime;

Thx Its work 100% with a little edit

Thx sir

[Admin]

@YT_Xaos

MySQL uses UTC to store the DateTime.

MySQL DATETIME fields are not timezone aware. You, the developer, have to make sure that the time zoning is correct.

If you ask MySQL for the current time, it will give you the system time. On free hosting, that’s set to EST (UTC-5). And because it’s the system time, you cannot change it, because it can only be changed for the entire server.

For this reason, it’s better to take the current time from PHP, because in PHP you can use timezones and set a default time zone.