change default date format in oracle

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.

next (#2) »

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!
0 0
2 followers
Viewed: 74 618 times
Version: 2.0
Category: How-tos
Tags: database
Written by: lenovo
Last updated by: samdark
Created on: Sep 17, 2019
Last updated: 5 years ago
Update Article

Revisions

View all history

Related Articles