Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_DATE_FORMAT using Instant Client

618658Jan 24 2008 — edited Feb 21 2008
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2008
Added on Jan 24 2008
6 comments
3,043 views