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