change default date format in oracle

You are viewing revision #6 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 or see the changes made in this revision.

« previous (#5)next (#7) »

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=...

Add this script inside your database connection file ` ......

// 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();

... `

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


View all history

Related Articles