pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Insert into:Bad date external representation
2+ messages / 2 participants
[nested] [flat]
* Re: Insert into:Bad date external representation
@ 2004-01-14 07:39 azwa@nc.com.my
0 siblings, 1 reply; 2+ messages in thread
From: azwa@nc.com.my @ 2004-01-14 07:39 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Insert into:Bad date external representation
@ 2004-01-14 08:24 Michael Glaesemann <grzm@myrealbox.com>
parent: azwa@nc.com.my
0 siblings, 0 replies; 2+ messages in thread
From: Michael Glaesemann @ 2004-01-14 08:24 UTC (permalink / raw)
To: azwa@nc.com.my; +Cc: pgsql-sql
On Jan 14, 2004, at 4:39 PM, azwa@nc.com.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-14 08:24 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-14 07:39 Re: Insert into:Bad date external representation azwa@nc.com.my
2004-01-14 08:24 ` Michael Glaesemann <grzm@myrealbox.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox