Re: Y2K: froms 4.5 'RR' format

From: <hoyt_chen_at_my-deja.com>
Date: Thu, 30 Sep 1999 12:45:45 GMT
Message-ID: <7svm1m$t4r$1_at_nnrp1.deja.com>


Hi,

Try 'DD-MON-RRRR' format!
In article <7ssln3$1hkh$1_at_news5.isdnet.net>,   "Frederic Arslanian" <frederic.arslanian_at_libertysurf.fr> wrote:
> I have the following instruction in forms 4.5 in pl/sql
>
> copy(name_in('block.item1') ,'block.item2');
>
> The date mask are 'dd/mm/rr' in forms.
> NLS_LANG_FORMAT is set to 'DD/MM/RR' in the registry but
> this instruction doesn't not give me back the right date.
>
> If i have to copy then following date '01/10/00' ,
> the date copied in the data base is '01/10/1900' instead of
'01/10/2000'
>
> If i enter a date in the field block.item2 instead of initialize it,
the
> date recorded is correct !!!!
>
> Any help would be appreciate.
>
> Thanks.
>
> Fred..
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 14:45:45 CEST

Original text of this message