Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Michael GlaesemannDate: 2004-01-14 08:24:13
Subject: Re: Insert into:Bad date external representation
Previous:From: StefDate: 2004-01-13 21:40:57
Subject: Historical logging of pg_stat_activity ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group