Thank you all very much. As mentioned, this isn't a mod_perl issue.
That NLS_ variable sounded familiar. I looked in my httpd.conf and found this:
PerlSetEnv NLS_LANG american_america.we8iso8859p1
Which controls (among many other things) the default date format.
I've moved that line out of the
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 fo
Jay Buffington wrote:
> Hi,
>
> I'm using DBI with DBD::Oracle. I've noticed that under scripts the
> default date format is mm/dd/ HH24:MI:SS, where as under mod_perl
> the default returned date format is -MM-DD.
>
> That is, if I select a date column from the database without wrapping
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/ HH24:MI:SS, where as under mod_perl
the default returned date format is -MM-DD.
That is, if I select a date column from the databa
Hi,
I'm using DBI with DBD::Oracle. I've noticed that under scripts the
default date format is mm/dd/ HH24:MI:SS, where as under mod_perl
the default returned date format is -MM-DD.
That is, if I select a date column from the database without wrapping
it in a TO_CHAR() function, I get d