Re: Insert dates into oracle from perl

[Steven Lembark]

-- Jay Strauss <[EMAIL PROTECTED]>

> With so little info provided, its anyone's guess, so mine is:
>
> You aren't casting a perl string to an oracle date with to_date:
>
> i.e.
>
> $date = "01/01/02"
> $dbh->do("insert into table (datefield) values
> (to_date($date,'mm/dd/yy'))";

That or just set the NLS_DATE_FORMAT and make sure the
strings agree.

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582