Re: Forms45/Year 2000

From: Garry M. Filimonov <garry_at_fly.triniti.troitsk.ru>
Date: 1996/09/12
Message-ID: <01bba0a3$b18027a0$bf0000c5_at_Garry.triniti.troitsk.ru>#1/1

KEURBG <keurbg_at_aol.com> wrote in article <517vlq$7t3_at_newsbf02.news.aol.com>...
> Has anyone had experience in how to deal with the date fields for the year
> 2000
> We currently have 4.5 applications which use the Oracle date format ie
> DD-MON-YY. The year 2000 will require that the year field be 4 positions
> instead
> of 2. Any suggestions on how we should proceed?
>
> Thanks, Bill
>

If your date is between 1950-2049 you can use DD-MON-RR :

SQL> select to_char(to_date('010150','ddmmrr'),'dd-MON-yyyy') from dual;

TO_CHAR(TO_DATE('010150','DDMMRR'),'DD-MON-YYYY')

---

01-JAN-1950 SQL> select to_char(to_date('311249','ddmmrr'),'dd-MON-yyyy') from dual;

TO_CHAR(TO_DATE('311249','DDMMRR'),'DD-MON-YYYY')

---

31-DEC-2049-JAN-2001

-- 
G'luck !
-----------------------------------------
Garry M. FIlimonov
LASU TRINITI, Troitsk, MO, Russia
garry_at_triniti.troitsk.ru

Received on Thu Sep 12 1996 - 00:00:00 CEST