Re: Year 2000 Recommendations?

From: John Jones <jmj22026_at_us1j69.glaxo.com>
Date: 1996/04/16
Message-ID: <4l0385$ml9_at_ussun2n.glaxo.com>#1/1

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????

John Jones
Oracle Consultant
jmj22026_at_us1j69.glaxo.com
My views are my own, no matter where they originate Received on Tue Apr 16 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Lee Levy: "Re: Year 2000 Recommendations?"
Previous message: Chuck Isaacson: "Re: HELP!! can not create table ..."
In reply to: Andrew Zitelli: "Year 2000 Recommendations?"
Next in thread: Lee Levy: "Re: Year 2000 Recommendations?"
Reply: Lee Levy: "Re: Year 2000 Recommendations?"
Reply: Rick Rutt: "Re: Year 2000 Recommendations?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message