On 8/25/06, Jay Buffington <[EMAIL PROTECTED]> wrote:
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
I am pretty sure it has nothing to do with mod_perl. You are probably
using sqlplus to run the queries directly and there may be some
configuration setting that controls the date format for sqlplus. When
you are executing queries from Perl, your date format might be falling
back on some default. HTH.
Arshavir
