Re: Y2K script?

From: Oracleguru <oracleguru_at_mailcity.com>
Date: Fri, 30 Oct 1998 21:24:57 GMT
Message-ID: <01be045c$40c1d620$a504fa80@mndnet>

Yes. I have several but they are in UNIX on SUN. You cannot tell from data but you have to look at the column name to figure out whether it contains date type data.

Basic concept is that you first get all the date type columns from Oracle data dictionary table
ALL_TAB_COLUMNS. Then you write a shell script to search(grep) a directory for files that contain these columns and other columns that may sound like they may contain date information such as 2 digit year ( e.g. number BUDGET_YR(2)) etc.

Good luck

Oracleguru

Nathan Merrill <nwm3_at_email.byu.edu> wrote in article <36378770.B5547BE0_at_email.byu.edu>...
> Does any one have a script that searches through data and returns if
> there are date problems or not for dates stored as text formats? I know
> Oracle is Y2k compliant but I also know applications can put dates in
> numerical or character formats.
>
> Thanks in advance
>
> Nathan Merrill
>
>
Received on Fri Oct 30 1998 - 15:24:57 CST