racle.
Regards,
Mike
-Original Message-
From: Ian Harisay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 12, 2008 4:01 PM
To: dbi-users@perl.org
Subject: RE: Using to_dsinterval or INTERVAL with placeholder
Sorry, I haven't tried anything to test what I am about to recommend.
placeholders. There's got to be a syntax that works
> - that will load INTERVAL DAY to SECOND
>
> Mike
>
>
> -Original Message-
> From: Lamb Joseph [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 12, 2008 10:42 AM
> To: dbi-users@perl.org
> Subject:
-Original Message-
From: Lamb Joseph [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 12, 2008 10:42 AM
To: dbi-users@perl.org
Subject: Re: Using to_dsinterval or INTERVAL with placeholder
Mike,
Here are some of the things that I would do.
1. Set the NLS Date Format
Example I pulled fr
to SECOND
Mike
-Original Message-
From: Lamb Joseph [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 12, 2008 10:42 AM
To: dbi-users@perl.org
Subject: Re: Using to_dsinterval or INTERVAL with placeholder
Mike,
Here are some of the things that I would do.
1. Set the NLS Date Format
E
Mike,
Here are some of the things that I would do.
1. Set the NLS Date Format
Example I pulled from the internet
# set Oracle NLS date format
if ( $optctl{dateformat} ) {
$dbh->do(qq{alter session set nls_date_format
= '$optctl{dateformat}'} );
}
2. Using bind_param set all your paramete