Re: Insert into:Bad date external representation

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

Responses

Browse pgsql-sql by date

  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 ?