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'))";
Jay
----- Original Message -----
From: "Rick Windham - ISDLIS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 9:10 AM
Subject: Insert dates into oracle from perl
> Im trying to insert into a date field in oracle using perl. No problem
inserting char
>
> data but I get a error inserting using the same technique into a date
field...
>
> any help is always appreciated
>
> rickw
>
> --
> ===============================
> Rick Windham |
> DATABASE ADMINISTRATOR |
> MANATEE COUNTY GOVERNMENT ISD |
> 941-749-3075 |
> 941-749-3086 (fax) |
> [EMAIL PROTECTED] |
> ===============================
>
>
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
