Re: different default oracle date formats under mod_perl and scripts

2006-08-26 Thread Jay Buffington
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

Re: different default oracle date formats under mod_perl and scripts

2006-08-26 Thread Tom Schindl
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

Re: different default oracle date formats under mod_perl and scripts

2006-08-25 Thread Philip M. Gollucci
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

Re: different default oracle date formats under mod_perl and scripts

2006-08-25 Thread Arshavir Grigorian
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

different default oracle date formats under mod_perl and scripts

2006-08-25 Thread Jay Buffington
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