Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Y2K question

Y2K question

From: Dave Morse <dmorse_at_nospam.cinergy.com>
Date: Tue, 4 Aug 1998 17:11:16 -0500
Message-ID: <6q80um$fq3$1@news.iquest.net>


I recently read a quote in a publication that said:

"And then, of course, there is the dreaded Year 2000 problem in Oracle. If your code contains lines like this: v_mydate := TO_DATE(v_mystr, 'mm/dd/yy'); -- then you have some big problems coming down the pike."

Do you agree? The TO_DATE function converts strings to the default system date. In the above example, the 'mm/dd/yy' is simply telling Oracle what format the string 'v_mystr' is in, not what to convert it to.

--

Dave
dmorse_at_cinergy.com (** please remove the 'nospam' from the address **) Received on Tue Aug 04 1998 - 17:11:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US