Re: Forms 3, Year 2000 AND 29 February

From: Chris Eastwood <c.eastwood_at_gu.edu.au>
Date: Thu, 11 Jun 1998 01:15:35 GMT
Message-ID: <6lnb46$b4q$1_at_kraken.itc.gu.edu.au>

In article <6lloqh$ktv$1_at_news.IT.net>, "Giuseppe Volta" <gvolta_at_pn.itnet.it> wrote:
>I use Forms 3, I have read the workaround for year 2000 on oracle official
>site:
>1 change from date to datetime
>2 use to_date(to_char(mydate,'DD-MON-YY'),'DD-MON-RR')
>It does works but not for 29-feb-2000.
>Can anyone help?
>Thanks in advance.
>Giuseppe
>
>
>
>
HiYa

works fine on our Y2K test system

SQL_at_DEV>select to_char(to_date('29-feb-00','DD-mon-RR'),'DD-MON-YYYY')   2 from dual;
-- more >  

TO_CHAR(TO_DATE('29-FEB-00','DD-MON-RR'),'DD-MON-YYYY')

---

29-FEB-2000   SQL_at_DEV>select to_char(sysdate,'DD-MON-YYYY')   2 from dual;
-- more >  

TO_CHAR(SYSDATE,'DD-MON-YYYY')

---

21-JAN-2000   SQL_at_DEV>

what version of Oracle are you using? I think that there is more needed for pre 7.3 versions (like NLS_DATE_FORMAT or something like that)

good luck

See Ya
(when bandwidth gets better ;-)

Chris Eastwood

Photographer, Programmer               email    ua.ude.ug.cti_at_doowtsae.c
Motorcyclist and dingbat               WWW   http://chrise.itc.gu.edu.au

************************************************************************

Ohhh ... you work all day, slave over a hot stove all night  yet you *still* have time for sadomasochism ... how do you do it?

A little man hurts me.

<ding>

    Oh Mister Mean ... Oh Mister Mean
    15 Minutes with him and you'll be blue and green     Studded belts and leather whips
    Bondage trousers on his hips
    Wack and punish as you dust with Mister Mean   Ohhhh he whips me around the house in minutes ... lets get cracking ... Received on Thu Jun 11 1998 - 03:15:35 CEST