Re: Insert into:Bad date external representation - Mailing list pgsql-sql

From azwa@nc.com.my
Subject Re: Insert into:Bad date external representation
Date
Msg-id OF93B7B966.7EC9812A-ONFFFFFF49.00458A6D@nc.com.my
Whole thread Raw
Responses Re: Insert into:Bad date external representation
List pgsql-sql
<br /><font face="Times New Roman" size="2">Hi,</font><br /><br /><br /><font face="Times New Roman" size="2"> got an
erroras below :</font><br /><br /><font face="Times New Roman" size="2">   dwnc=> insert into
biosadm.custdo_dim</font><br/><font face="Times New Roman" size="2">dwnc->
 (do_key,do_no,do_date,attnto,custlo)</font><br/><font face="Times New Roman" size="2">dwnc->  select
nextval('cdo_seq'),c.dono::varchar,c.dodate::date,</font><br/><font face="Times New Roman" size="2">dwnc-> c.attnto,
c.custlo from custdo_temp c;</font><br /><font face="Times New Roman" size="2">ERROR:  Bad date external representation
''</font><br/><br /><br /><font face="Times New Roman" size="2">Table structure (custdo_dim) :   </font><br /><br
/><fontface="Times New Roman" size="2">dwnc(> \d custdo_dim</font><br /><font face="Times New Roman" size="2">     
           Table "biosadm.custdo_dim"</font><br /><font face="Times New Roman" size="2"> Column  |  Type   |          
     Modifiers</font><br /><font face="Times New Roman"
size="2">---------+---------+-------------------------------------------</font><br/><font face="Times New Roman"
size="2"> do_key | integer | not null default nextval('cdo_seq'::text)</font><br /><font face="Times New Roman"
size="2"> do_no  | text    |</font><br /><font face="Times New Roman" size="2"> do_date | date    |</font><br /><font
face="TimesNew Roman" size="2"> custlo  | text    |</font><br /><font face="Times New Roman" size="2"> attnto  | text  
 |</font><br/><font face="Times New Roman" size="2">Indexes: custdo_dim_pkey primary key btree (do_key)</font><br /><br
/><br/><font face="Times New Roman" size="2">Table structure(custdo_temp):</font><br /><br /><font face="Times New
Roman"size="2"> Table "biosadm.custdo_temp"</font><br /><font face="Times New Roman" size="2">  Column  | Type |
Modifiers</font><br/><font face="Times New Roman" size="2">----------+------+-----------</font><br /><font face="Times
NewRoman" size="2"> dono     | text |</font><br /><font face="Times New Roman" size="2"> dodate   | text |</font><br
/><fontface="Times New Roman" size="2"> custname | text |</font><br /><font face="Times New Roman" size="2"> custlo   |
text|</font><br /><font face="Times New Roman" size="2"> attnto   | text |</font><br /><br /><font face="Times New
Roman"size="2">pls help me thanks</font> 

pgsql-sql by date:

Previous
From: Stef
Date:
Subject: Historical logging of pg_stat_activity ?
Next
From: Michael Glaesemann
Date:
Subject: Re: Insert into:Bad date external representation