got an error as below :^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
dwnc=> insert into biosadm.custdo_dim dwnc-> (do_key,do_no,do_date,attnto,custlo) dwnc-> select nextval('cdo_seq'),c.dono::varchar,c.dodate::date, dwnc-> c.attnto, c.custlo from custdo_temp c; ERROR: Bad date external representation ''
Here's your clue right here: It means the dodate text field in custdo_temp contains data that does not represent a valid date. Check to make sure custdo_temp.dodate is all properly formatted.
HTH
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
