Hi, How to fix NLS_DATE_FORMAT problem without altering the session? Like NO TDATE ---------- --------- 10 24-JUN-04 20 24-JUN-04 I want like NO TDATE ---------- ---------- 10 2004-06-24 20 2004-06-24 Is any parameter which need to setup at init.ora file? I tried yyyy-mm-dd but didn't helped? I want whole table data should be like "yyyy-mm-dd'. pLEASE suggest if any? thx _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar ? get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------