I have been researching how to change the oracle instance date format at the session level. The only thing that seems to work is using a tigger that sets does a alter session per login into the database. It appeasr that changing the registry for Oracle 8i was all that was required, but that does not work for Oracle 9i. To keep from going crazy I would like to know if I am correct?