Re: different default oracle date formats under mod_perl and scripts

["Arshavir Grigorian" <suppressed>]

On 8/25/06, Jay Buffington <suppressed> 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