how to change the date format using initSQL from weblogic console

(Doc ID 2238653.1)

Last updated on MARCH 01, 2017

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 "", 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



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms