> 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.

My results using Perl 5.6.1, DBI::Oracle 1.12, DBI 1.30, Oracle 8.1.6:

2003/01/27 12:03:03

----
Steve Sapovits
GSI Commerce  http://wwww.gsicommerce.com
[EMAIL PROTECTED] 

Reply via email to