On Jan 14, 2004, at 4:39 PM, azwa(at)nc(dot)com(dot)my wrote:
> 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