Difference between #12 and #13 of
Change default date format in Oracle

Revision #13 has been created by samdark on Sep 20, 2019, 6:15:25 AM with the memo:

Improved markdown
« previous (#12) next (#14) »

Changes

Title unchanged

change default date format in oracle

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',
[...]
0 0
2 followers
Viewed: 73 010 times
Version: 2.0
Category: How-tos
Tags: database
Written by: lenovo
Last updated by: samdark
Created on: Sep 17, 2019
Last updated: 4 years ago
Update Article
Revert to #12 | Revert to #13

Revisions

View all history