I am trying to update the timestamp column in my Grid view to display the date and time in my local timezone.
[
'format' => [
'class' => 'yii\i18n\Formatter',
'timeZone' => 'Asia/Singapore',
],
'attribute' => 'created_at',
'label' => 'Date',
'filter' => false,
'value'=> function($model, $key, $index, $column){ return Search::getDateTime($model); }, }
'format' => 'raw',
]
Furthermore, I have added the following method to my search model:
public static function getDateTime($model) {
$date = Yii::$app->formatter->asDate($model->created_at);
$time = Yii::$app->formatter->asTime($model->created_at);
return Html::a($date, null, ['href' => 'javascript:void(0);', 'class' => 'btn btn-link p-0 rounded-0 tooltips', 'data-toggle' => 'tooltip', 'data-placement'=> 'bottom', 'title' => $time]);
}
In addition to that, make sure your main.php components include the following configuration for the Formatter:
'formatter' => [
'class' => 'yii\i18n\Formatter',
'dateFormat' => 'php:j M Y',
'datetimeFormat' => 'php:d/m/Y h:i a',
'timeFormat' => 'php:H:i A',
'defaultTimeZone' => 'Asia/Singapore'
],
The timestamps in my database are saved as UTC. For example, 2021-11-22 11:28:16.
If you want to display the correct time based on your timezone (Asia/Singapore), ensure that you follow the steps mentioned above.