From: | azwa(at)nc(dot)com(dot)my |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Insert into:Bad date external representation |
Date: | 2004-01-14 07:39:34 |
Message-ID: | OF93B7B966.7EC9812A-ONFFFFFF49.00458A6D@nc.com.my |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
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 ''
Table structure (custdo_dim) :
dwnc(> \d custdo_dim
Table "biosadm.custdo_dim"
Column | Type | Modifiers
---------+---------+-------------------------------------------
do_key | integer | not null default nextval('cdo_seq'::text)
do_no | text |
do_date | date |
custlo | text |
attnto | text |
Indexes: custdo_dim_pkey primary key btree (do_key)
Table structure(custdo_temp):
Table "biosadm.custdo_temp"
Column | Type | Modifiers
----------+------+-----------
dono | text |
dodate | text |
custname | text |
custlo | text |
attnto | text |
pls help me thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2004-01-14 08:24:13 | Re: Insert into:Bad date external representation |
Previous Message | Stef | 2004-01-13 21:40:57 | Historical logging of pg_stat_activity ? |