Magento2: Date showing wrong on grid column

Question

I created one grid and showed the date there. Database data and grid values are not matched. Grid value showing 1 back date instead of same as database.

Below is my DB table value:

And below code snippet I am using for grid column value:

$this->addColumn('process_ship_date', array(
            'header'    => __('Process Ship Date'),
            'type'      => 'date',
            'index'     => 'process_ship_date'
        ));

And below are my grid value:

Also, the date format does not match in Grid.

Can anyone please look into this.

Answer 1

Magento Store Date in UTC format in Database. While in Grid it will convert from UTC to Your magento store time.

So, save date in database in UTC format.

Answer 2

If you want to render a date without timezone changes just add property timezone to column

        $this->addColumn('process_ship_date', array(
            'header'    => __('Process Ship Date'),
            'type'      => 'date',
            'timezone'  => false,
            'index'     => 'process_ship_date'
        ));