Change default date format in Oracle

Comparing #4 with #5

Revision #5 was created by lenovo on Sep 17, 2019, 10:29:48 AM.

code formatting

Content

[...]

Too solve this issue, we must change date format oracle like date commonly using
```
ALTER SESSION SET NLS_DATE_FORMAT=...
```

For complete script

```

return [

    'class' => 'yii\db\Connection',

    'dsn' => 'oci:host=127.0.0.1:1521/XE',

    'username' => 'YOUR_USERNAME',

    'password' => 'YOUR_PASSWORD',

    'charset' => 'utf8',

Add this script inside your database connection file

```

......
// Schema cache options (for production environment)
//'enableSchemaCache' => true,

[...]

$event->sender->createCommand("ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY hh24:mi:ss'")->execute();
}
];... ```