Yii Framework Wiki
Difference between
#8 and
#14 of
Change default date format in Oracle
Changes
Title changed
Category unchanged
How-tos
Yii version unchanged
2.0
Tags unchanged
database
Content changed
Default date format in oOracle 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
```sql ALTER SESSION SET NLS_DATE_FORMAT= = ...
```
Add this script inside your database connection file
```php
<?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,
$event->sender->createCommand("ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY hh24:mi:ss'")->execute();
}
]; ```
Too solve this issue, we must change date format oracle like date commonly using
```sql ALTER SESSION SET NLS_DATE_FORMAT
```php
<?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,
[...]
// $event->sender refers to the DB connection$event->sender->createCommand("ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY hh24:mi:ss'")->execute();
}
]; ```
2 followers
Viewed: 74 635 times
Version: 2.0
Category: How-tos
Written by: lenovo
Last updated by: samdark
Created on: Sep 17, 2019
Last updated: 5 years ago
Revisions
View all history-
5 years ago by
samdark Improved title
-
5 years ago by
samdark Improved markdown
-
5 years ago by
lenovo content formating
-
5 years ago by
lenovo content formating
-
5 years ago by
lenovo content formating
-
5 years ago by
lenovo content formating
-
5 years ago by
lenovo code formatting
-
5 years ago by
lenovo code formatting
-
5 years ago by
lenovo code formatting
-
5 years ago by
lenovo code formatting