Re: Forms 3.0, Rpt and Year 2000

From: Chris Eastwood <c.eastwood_at_gu.edu.au>
Date: Mon, 06 Jul 1998 06:47:18 GMT
Message-ID: <6npruv$j83$1_at_kraken.itc.gu.edu.au>

HiYa

In article <359fa574.27737600_at_news.xs4all.nl>, dewildeh.THOU_SHALT_NOT_SPAM_at_xs4all.nl (Henk de Wilde) wrote:
>
>The principle is to let all date conversions be done in the database
>with one of Oracle's new "RR" format string. As long as the original
>developers used the DATE column type for dates that should solve your
>problem.

Yep, however I think that it isn't so crash hot in all instances

[Quoted] Eg if you are dealing with Birthdates, its possible that the birthdate of 01-FEB-45 is a legitamate one for a person living now, however the RR option gives this on our Y2K test box:

select substr(to_char(sysdate,'DD-MON-YYYY'), 1,13) from dual;
-- more >
SUBSTR(TO_CHA

---

16-FEB-2000 select substr(

         to_char(
             to_date('01-FEB-45','DD-MON-RR'),
             'DD-MON-YYYY'), 1,13)

from dual;

SUBSTR(TO_CHA

---

01-FEB-2045 We have a proceduure that treats dates of birth seperately.

>One important bug :
>All DATE fields will have to be changed to DATETIME. Else the
>procedure will not help.

this one had me for a while, one of the other guys here stumbled over it by accident .. Actually, one could just change the field to length 11 and force a format mask of DD-MON-YYYY, however this does depend on the availability of space.

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 Mon Jul 06 1998 - 08:47:18 CEST