Set database connection timezone in Yii2 application
- By Preneesh AV --
- 06-Oct-2019 --
- 167 Comments
Set database connection timezone in Yii2 application
| edit common/config database settings |
| 'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=localhost;dbname=preneesh', 'username' => 'preneesh', 'password' => 'preneesh', 'on afterOpen' => function($event) { $event->sender->createCommand("SET time_zone='+05:30';")->execute(); }, 'charset' => 'utf8' ], |
