MySQL-PHP get and echo NOW() value?

mysqld
default-time-zone='timezone'
SETGLOBAL time_zone =timezone;

<?php
$query = "SELECT NOW() as `now`";
$result = $mysqli->query($query);
$row = $result->fetch_array();
$now = $row['now'];
echo "$now\n";
?>

Reference:
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
https://stackoverflow.com/questions/16094232/mysql-php-get-and-echo-now-value

Attachments (1)

• my_copy1.cnf (394 Views, 1.75 KB)