Date column shows wrong time
Posted: Thu May 08, 2025 9:22 am
I have the following Php code in BB section of browse only form:
In PhpMyAdmin, the query runs correctly and the test_date column shows date according to current time zone.
But in the browser, the column shows incorrect time. Please see attached screenshots:
Code: Select all
//$currentDate = date("YYYY-MM-DD");
$currentDate = "#date_filter#";
$select = "
SELECT
(FROM_UNIXTIME(scores.timestamp)) as test_date,
scores.*,
users.*,
procedures.*
FROM
scores
JOIN users ON scores.user_id = users.users_id
JOIN procedures ON scores.procedure_id = procedures.procedures_id
WHERE DATE(FROM_UNIXTIME(`timestamp`)) = '$currentDate'";
nuCreateTableFromSelect('#TABLE_ID#', $select);
But in the browser, the column shows incorrect time. Please see attached screenshots: