Re: suggestions sought on returning rows from oracle proc and deleting them in same proc

[Douglas Wilson]

On Wed, Oct 22, 2008 at 9:12 AM, Martin Evans <[EMAIL PROTECTED]> wrote:
> John Scoles wrote:
>>
>> Well what you might want to do is convert the out data like this
>>
>> SELECT SYSTIMESTAMP,to_char(SYSTIMESTAMP,'mm-yyyy-dd:hh:sssss') FROM dual

I usually just add this after every connect():
    $dbh->do("alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'");
    $dbh->do("alter session set nls_timestamp_format='YYYY-MM-DD
HH24:MI:SS.FF'");