A couple others have sent you solutions for your date issue. I tend to
prefer the ALTER SESSION method for selects and TO_DATE() for WHERE clauses.
'DD-MON-YY' is the default date format in the database, not Perl.
DBD::Oracle and DBI just pass through the string value the database
retrieves for dates.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Price, Pauline" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 9:09 AM
Subject: problem with format of returned oracle dates for text file output
>. . .
> Of course if the format that I am getting currently, DD-MMM-YY, is
> controlled by
> some Perl default, please point me at the setting - I'd be so happy.
