I recently migrated a database from MS Access with a date column specified as MM/DD/YYYY. After migrating to Oracle I noticed the date column shows as 2098 instead of 1998. I tried using 'RRRR' instead of 'YYYY' but it still shows as 2098. Is there a work around for this problem? I'd hate to go thru the migration again.
thanks!!
Randy