help - changing all dates in database??
From: Me <kark_1999_at_yahoo.com>
Date: Thu, 02 May 2002 13:50:32 GMT
Message-ID: <IubA8.78546$WV1.23947179_at_typhoon.ne.ipsvc.net>
Date: Thu, 02 May 2002 13:50:32 GMT
Message-ID: <IubA8.78546$WV1.23947179_at_typhoon.ne.ipsvc.net>
I have a strange problem that I must resolve:
In my company's huge database, I have to look at all of the date columns and
do the following....
- If the year is < 2000, I have to change it to 2000.
Now, I have 2 questions (or request for suggestions):
1. Is there a way to search the database and return every column or database
that contains a date datatype?
2. Is there an easy way to inspect the contents of the date (just the year)
and make these changes?
Any suggestions would be great!
THANKS.
Received on Thu May 02 2002 - 15:50:32 CEST