Re: Y2k problem with 7.3.4

Arjan van Bentem wrote
>Carl: you might want to run the script below to check for that.

In fact, the script was used to search years like 0099 (caused by applying to_date(..) on a date like I mentioned a couple of times before). It won't help you to find 1900 values, unless you change it to something like:

    l_result := ExecQuery

       (  'select count(*)'
       || ' from ' || r_DateCols.table_name
       || ' where ' || r_DateCols.column_name || ' is not null'
       || ' and to_num( ' || r_DateCols.column_name || ', ''YYYY'')'
       || ' not between 1950 and 2049'
       );

Arjan. Received on Tue Mar 02 1999 - 14:00:54 CST