I use UnixDate and ParseDate (both in Date::Manip) to get the date and time formatted in Perl to whatever the NLS_DATE_FORMAT is set to in Oracle. The alternative to that would be have a TO_DATE in the SQL and explicitly coerce the date string.

rdfield