NLS_DATE_FORMAT using Instant Client
618658Jan 24 2008 — edited Feb 21 2008I am using Oracle Instant Client 11.0.1 on 64-bit Linux
I have set the variable in /etc/bashrc as
export NLS_DATE_FORMAT='MM/DD/YYYY HH12:MI:SS AM'
but when I try:
<?php
$conn = oci_pconnect('user', 'pass', 'service') ;
$query="select sysdate from dual";
$stmt = ociparse($conn,$query);
ociexecute($stmt);
$sysID= array() ;
ocifetchinfo($stmt,#sysID);
echo $sysID[0] ;
?>
I get:
24-JAN-08
Please tell me if there is a way without using ALTER SESSION, which i can accomplish this.