Re: Date-format

In article <4p9j2n$gvq_at_news1.Belgium.EU.net>, yves <an543896_at_anon.penet.fi> writes:
|> Hello,
|>
|> A newcomer with, I hope,a very simple question.
|>
|>
|> I 'am using Oracle RDBMS 7 and forms 4.5.
|> Dateformats on forms are as followes : 01-MAY-1996
|> Would like to alter this into 1-6-1996 or 01-06-1996.
|> Is this possible and how ?
|> (is there a parametersetting in oracle.ini perhaps ?)
|>
|> Many thanks in advance.
|>
|> Jan Van den Bosch
You can change the default date format using the INIT.ORA parameter NLS_DATE_FORMAT. If you change it there, it will effect the entire database. You can also change it on a session-by-session basis using an ALTER SESSION command:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY'; for example.

-- 
------------------------------------------------------------------------
Scott Urman            Oracle Corporation           surman_at_us.oracle.com
------------------------------------------------------------------------
Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2
Published by Oracle Press - http://www.osborne.com/oracle/index.htm
------------------------------------------------------------------------
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"
------------------------------------------------------------------------