El lun, 12-01-2004 a las 10:12, [EMAIL PROTECTED] escribió: > > Hi, > ..../.... > > My SELECT STATEMENT : > > dwnc=> insert into cust_lo_dim > dwnc-> (lo_no,lo_date,rcvdate,lo_status) > dwnc-> select c.lono,c.lodate,c.rcvdate,c.status > dwnc-> from custlo_temp c ; > ERROR: column "lo_date" is of type date but expression is of type > text > You will need to rewrite or cast the expression > Questions : > > 1) How to rewrite /cast the expression above ??? same goes to > others column .
Insert into cust_lo_dim (lo_no, lo_date, rcvdate, lo_status) select c.lono, c.lodate::date, c.rcvdate::date, c.status from custlo_temp c; > 2) lo_key is the column which values comes from sequence clo_seq. what > should i do first b4 insert into cust_lo_dim ???? ??? Nothing. Are you getting some error? -- Gabriel Dovalo
signature.asc
Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada digitalmente
