Oracle + NLS_DATE_FORMAT
| From: | j0rd1 Adame | Date: | Fri, 16 May 2003 21:30:40 +0000 |
| Subject: | Oracle + NLS_DATE_FORMAT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27835@lists.php.net to get a copy of this message | ||
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