Re: nls_date_format in initSID.ora

From: Sergey Keberle <prog_at_unisoft.dp.ua>
Date: Mon, 3 Sep 2001 10:32:29 +0400
Message-ID: <7572088@unisoft.com>

Hi
Try to use environment parameter.
I think it does what tou want

Hi
Sergey
  <simon.pospisil_at_fastsearch.com> wrote in message news:3B8F9815.5D29074A_at_fastsearch.com...   Hello, I've tried changing the nls_date_format variable from:   nls_date_format = DD-MON-YYYY
  to
  nls_date_format = YYYY-MM-DD
  Then I restart the database but it will only use the old format, the new   format has not been recognised. I'm editing the initSID.ora file where   SID is the sid of the database in question. Is that right? However, if    I alter the format within a session then it works fine.

Any ideas?

Cheers

Simon.

-- 


Simon Pospisil                          Mail:  simon.pospisil_at_fastsearch.com
Web Programmer                          Web:   http://www.fastsearch.com/
Fast Web Media Ltd.                     Phone: +44 (0) 161 835 3444
Suite 1202, Sunlight House Quay Street  Fax:   +44 (0) 161 835 3488
Manchester, England M3 3JZ

Try FAST Search: http://www.alltheweb.com
Try: www.megasoccer.com
Try: www.fa-premier.com

Received on Mon Sep 03 2001 - 01:32:29 CDT