Date column shows wrong time Topic is solved

[nadir]

I have the following Php code in BB section of browse only form:

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);

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:

Screenshot 2025-05-08 122006.png

Screenshot 2025-05-08 122030.png

[kev1n]

Hi,

It could be due to the time zone setting (Setup -> Settings)

[nadir]

Yes, that was causing the issue. I set the time zone under Setup and that fixed the issue. Thanks