pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: azwa@nc.com.my
To: pgsql-sql@postgresql.org
Subject: Re: Insert into:Bad date external representation
Date: Wed, 14 Jan 2004 15:39:34 +0800
Message-ID: <OF93B7B966.7EC9812A-ONFFFFFF49.00458A6D@nc.com.my> (raw)

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

view thread (2+ messages)  latest in thread

Message-ID: <OF93B7B966.7EC9812A-ONFFFFFF49.00458A6D@nc.com.my>
Permalink:  ../OF93B7B966.7EC9812A-ONFFFFFF49.00458A6D@nc.com.my/
Also on:    postgresql.org/message-id/OF93B7B966.7EC9812A-ONFFFFFF49.00458A6D@nc.com.my

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: azwa@nc.com.my
  Subject: Re: Insert into:Bad date external representation
  In-Reply-To: <OF93B7B966.7EC9812A-ONFFFFFF49.00458A6D@nc.com.my>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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