[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

different default oracle date formats under mod_perl and scripts


Hi,

I'm using DBI with DBD::Oracle.  I've noticed that under scripts the
default date format is mm/dd/yyyy HH24:MI:SS, where as under mod_perl
the default returned date format is YYYY-MM-DD.

That is, if I select a date column from the database without wrapping
it in a TO_CHAR() function, I get different results under mod_perl.

I find this curious.  Is this a configuration option somewhere?  If so
where can I change it?

Thanks,
Jay


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.