how to change the date format using initSQL from weblogic console
(Doc ID 2238653.1)
Last updated on SEPTEMBER 24, 2018
Applies to:Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.
How to enable the feature of Initializing Database Connections with SQL Code
As documented in "https://docs.oracle.com/middleware/1212/wls/JDBCA/jdbc_datasources.htm#JDBCA159", WebLogic Server runs SQL code using Init SQL attribute on the JDBC Data Source: Configuration: Connection Pool page in the Administration Console whenever it creates a database connection for the data source, which includes at server startup, when expanding the connection pool, and when refreshing a connection.
But This feature did not work for the below query
SQL alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
The same feature is working for Oracle forms and Reports
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document