DataTable show time 1 hour behind than what is in db

[petethewizard]

I have a DataTable set up to display "updated_at" from a table and my timezone in app.php is Europe/Berlin but the DataTable always displays the time 1 hour behind than what is stored in the db? Why is that happening? Is there a way to disable it? I assume this has something to do with the automatic detection of date fields. Also, when using editColumn on the datetime field is shows the correct time. However, I trying to find another way to fix this.

I am using version 11.0.0. Laravel 11. PHP 8.2. Any help appreciated!

[yajra]

Below is a DateTimeColumn I am using to display the time on the client timezone. Feel free to adjust as needed. Basically, I used moment JS to change the way the data is rendered on the client side.

<?php

declare(strict_types=1);

namespace App\Editor\Columns;

use Yajra\DataTables\Html\Column;

class DateTimeColumn extends Column
{
    public function __construct(array $attributes = [])
    {
        parent::__construct($attributes);

        $this->render('data ? moment(new Date(data)).format("MM/DD/YYYY hh:mm a"): ""')
            ->exportFormat('mm/dd/yyyy h:mm am/pm')
            ->width('170px');
    }
}

Usage

DateTimeColumn::make('updated_at'),