Change Date format for Schema only
is it possible to change the date format of the schema from dd/mm/yyyy to mm/dd/yyyy ?
I want to change it only for a specific schema .
it is not possible to change the date format on the schema level.
you can do this on the database instance level.
Thanks, I thought it could be done,
You can write your own PL/SQL function, and use that anytime you want to return a date in character format. That function could look at a table which would tell it what format to return dates in.
this space intentionally left blank
Why do not you write trigger at schema level to change the nls_date_format ?
create or replace trigger aftr_logon after logon on scott.schema
execute immediate 'alter session set nls_date_format=''mm/dd/yyyy''';
Bear in mind you have write this trigger for each of the schema that you want to change the date format.
Experience is a hard teacher because she gives the test first, the lesson afterwards.
Click Here to Expand Forum to Full Width