Difference between #7 and #8 of
Change default date format in Oracle

Revision #8 has been created by lenovo on Sep 17, 2019, 10:30:42 AM with the memo:

code formatting
« previous (#7) next (#9) »

Changes

Title unchanged

change default date format in oracle

Category unchanged

How-tos

Yii version unchanged

2.0

Tags unchanged

database

Content changed

[...]
ALTER SESSION SET NLS_DATE_FORMAT=...
```

Add this script inside your database connection file
```
......
 
 // Schema cache options (for production environment)
//'enableSchemaCache' => true,
//'schemaCacheDuration' => 60,
[...]
$event->sender->createCommand("ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY hh24:mi:ss'")->execute();
}
...
 
```
0 0
2 followers
Viewed: 74 607 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
Revert to #7 | Revert to #8

Revisions

View all history