Difference between #10 and #11 of
Change default date format in Oracle

Revision #11 has been created by lenovo on Sep 19, 2019, 1:19:31 AM with the memo:

content formating
« previous (#10) next (#12) »

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,
[...]
$event->sender->createCommand("ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY hh24:mi:ss'")->execute();
}
```

 
0 0
2 followers
Viewed: 3 334 times
Version: 2.0
Category: How-tos
Tags: database
Written by: lenovo
Last updated by: samdark
Created on: Sep 17, 2019
Last updated: a month ago
Update Article

Revisions

View all history