Two Oracle tech notes (available on MetaLink) that should be read by all concerning dates are 67423.1 and 69029.1. In particular, client settings can override the NLS_DATE_FORMAT set in the init.ora, and NO implicit date conversion is Y2K safe. Don't rely on any init parameter to prevent date conversion problems.