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

Home -> Community -> Mailing Lists -> Oracle-L -> Strange Date -- 00-JAN-00 !!!!!

Strange Date -- 00-JAN-00 !!!!!

From: Sunny Verghese <vsgeorge70_at_yahoo.com>
Date: Tue, 15 Oct 2002 16:58:21 -0800
Message-ID: <F001.004E9EF5.20021015165821@fatcity.com>

One of the DBAs I work with is trying to figure out how some of the records in a table with about 15 million records contains 00-Jan-00 in a specific date column. The table is populated using an application written in Power Builder. I don't know the history (if and when patches were applied / the database was upgraded). I saw a couple of notes on Metalink about upgrades causing something of this sort. Any ideas ???
Sunny          



Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sunny Verghese
  INET: vsgeorge70_at_yahoo.com
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 15 2002 - 19:58:21 CDT

Original text of this message

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