Hello, I've tried changing the nls_date_format variable from: nls_date_format = DD-MON-YYYY to nls_date_format = YYYY-MM-DD Then I restart the database but it will only use the old format, the new format has not been recognised. I'm editing the initSID.ora file where SID is the sid of the database in question. Is that right? However, if I alter the format within a session then it works fine. Any ideas? Cheers Simon. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
