You are viewing revision #1 of this wiki article.
This version may not be up to date with the latest version.
You may want to view the differences to the latest version.
Default date format in oracle is DD-MON-RR (25-JAN-18).
With that output, we can't using date formatting.
Too solve this issue, we must change date format oracle like date commonly using
ALTER SESSION SET NLS_DATE_FORMAT=...
For complete script
`
<?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,
//'schemaCache' => 'cache',
'on afterOpen' => function($event) {
// $event->sender refers to the DB connection
$event->sender->createCommand("ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY hh24:mi:ss'")->execute();
}
];
done!
If you have any questions, please ask in the forum instead.
Signup or Login in order to comment.