Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Y2K question
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
![]() |
![]() |