On Mon, 27 Jan 2003, Steve Haslam wrote:
> Doug:
>
> >To see what I mean try something like this:
> >$dbsrc->do("ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'") ||
> >die $dbsrc->errstr;
>
> >print "$_ " for $dbsrc->selectrow_array("select sysdate from dual") or die
> >"Couldn't get date $DBI->errstr";
>
> >it still shows as 24-JAN-03 for me.
>
> Odd-- it works fine here:
>
> bash$ perl -MDBI -e '$dbh = DBI->connect("dbi:Oracle:", "steveh", "");
> $\="\n"; print $dbh->selectrow_array("SELECT SYSDATE FROM dual");
> $dbh->do("ALTER SESSION SET nls_date_format=\x27DD Mon YYYY
> HH24:MI:SS\x27"); print $dbh->selectrow_array("SELECT SYSDATE FROM dual");'
> 27-JAN-03
> 27 Jan 2003 16:57:34
some final notes on this.
It works fine on a machine with oracle8(.1.X) libs against an oracle8
database server. It works from from an oracle9i machine against the
oracle9i server. It did not work from any machine with oracle8 libs to
an oracle9i server.
