Re: Year 2000 Recommendations?

John Jones <jmj22026_at_us1j69.glaxo.com> writes:  

> Just ran across the same problem the other day. We are using PowerBuilder as a
>frontend. We have to pass the date from PB in characters and then reconvert in a
>stored procs once it gets to Oracle. All you have to do is use the MM/DD/RR date
>format. Notice the "RR" instead of "YY". Oracle says if the year is 51 or greater
>then it is 1900, and if it is 50 or less then it is 2000. This works great unless
>the field you are working on is a birthday and you have people born before 1950.
>Anybody got any ideas how to handle this????
 

Yes.  

Have your DBA change the default INPUT format for the database from "DD-MON-YY" to "DD-MON-YYYY" so your SQL statements can refer to all four digits of the year. Remember that the database already stores enough bits in the date to contain the full year.  

• Rick --

(Rick Rutt is a system architect living and working in Midland, Michigan.) Received on Wed Apr 17 1996 - 00:00:00 CEST