Re: different default oracle date formats under mod_perl and scripts

[Tom Schindl <suppressed>]

Well maybe this is because if you run the scripts in the console you do
it as
another user with another environment than your apache is working. Try
to sync
the environment.

Tom

Jay Buffington 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