RE: [PHP-DB] Oracle + NLS_DATE_FORMAT

Oracle has a TOCHAR and TODATE function, which my help in what you are trying to do. Simply "force" the date in your query to the format you want it in. You can find out more with a simple google search on these terms. TO_DATE('01-FEB-2002' ,'dd-mon-yyyy') - Paul -----Original Message----- From: j0rd1 Adame [mailto:jordi@jordi.net] Sent: Friday, May 16, 2003 4:31 PM To: php-db@lists.php.net Subject: [PHP-DB] Oracle + NLS_DATE_FORMAT Hello I have put NLS_DATE_FORMAT in my client machine (Linux) to be YY-MM-DD, but when I use PHP, i get dates in the YY-mon-DD format I tried using putenv('NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS"'); I added export NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS" to /usr/sbin/apatchectl and restarted Apache I tried using NLS_DATE_FORMAT as a global variable for my whole system and still nothing I tried using $stmt = OCIParse($conn, "ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'"); OCIExecute($stmt); and yet... nothing any ideas? j0rd1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php