On Mon, 2005-06-13 at 09:44, Moon, John wrote:
> ... jwm wrote
>
> "IF" this is the way you choose to build your update/insert statements
> please be aware that "date" formats vary by session... So you would need to
> either do a to_date function and different mask for each date you handle or
> set the session date format {my $sth = $dbh->prepare(q{alter session set
> NLS_DATE_FORMAT = 'dd-Mon-YYYY'}); ...} AND convert each date to that
> format... As for knowing the "type" of column for an insert/update I have
> not had any problems (or need), with Oracle, to know the "type" of the
> column when using placeholders EXCEPT for date types... SO I'm not sure
> where your problem is unless it is dates... I use Oracle versions 7.x to
> 9.x... (There are "types" that I have NOT used - "glob" for one)
I have found the Date::Manip package extremely useful in the
manipulation of unknown date formats.
It can easily convert unknown formats to known format so that
you only have to deal with a single format in your SQL.
Jared
