Re: Date and year 2000?
From: Govindhan Padmavijayam <govind_at_bns01.attmail.com>
Date: 1995/11/28
Message-ID: <DIrvIw.B6G_at_nntpa.cb.att.com>#1/1
Date: 1995/11/28
Message-ID: <DIrvIw.B6G_at_nntpa.cb.att.com>#1/1
Hi,
You could do :
ALTER SESSION SET NLS_DATE_FORMAT=MM/DD/RR or in your init<sid>.ora, set :
NLS_DATE_FORMAT=MM/DD/RR RR makes the date "century concious".
hth,
Govind.
Received on Tue Nov 28 1995 - 00:00:00 CET