Change default date format in Oracle

Comparing #11 with #12

Revision #12 was created by lenovo on Sep 19, 2019, 1:21:07 AM.

content formating

Content

[...]

```

Add this script inside your database connection file

```
<?php

return [

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

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

    'username' => 'your_username',

    'password' => 'your_password',

    'charset' => 'utf8',

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

[...]

// $event->sender refers to the DB connection
$event->sender->createCommand("ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY hh24:mi:ss'")->execute();
}

]; ```