Urgent!! Date format change

From: Mike Ng <mike_at_email.tech-trans.com>
Date: 2000/04/07
Message-ID: <38ed9ced_2@news1.prserv.net>#1/1

Hi all,

I want to use the date format like this "DD-MM-YYYY HH24:MI:SS" but I need use the sql
"alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS" to setup the environment every time I login.

I have try to add the following format in init.ora file but it did not work. The string I add is NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS" Is there elsewhere I need to change? I want to change it permanently in server side. Or this parameter can only be changed in client side. Please give me some hints.

Thanks a lot.

Regards,
Mike Ng Received on Fri Apr 07 2000 - 00:00:00 CDT