Message-ID: <4799EF03.30203@sympatico.ca>
Date: Fri, 25 Jan 2008 09:15:31 -0500
From: Frank Bax <fbax@sympatico.ca>
User-Agent: Thunderbird 2.0.0.6 (X11/20070818)
MIME-Version: 1.0
To: iuri.sampaio@computer.org,  pgsql-sql@postgresql.org
Subject: Re: date format
References: <1201162018.7883.12.camel@COMPAQ>
In-Reply-To: <1201162018.7883.12.camel@COMPAQ>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

iuri de araujo sampaio wrote:
> hi,
> 
> how to change the default format for type date?
> I have created a field on a table:
> 
> ##
> create table tbl_inventory (
>         item_id integer constraint c_pk primary key,
>      I.         purchase_date date,
>     II.         fabrication_date date,
>    III.         expiration_date date
> );
> ##
> 
> the error i got is: 
> 
> ##
> Database operation "dml" failed
> (exception ERROR, "ERROR:  invalid input syntax for type date: "2008 7 22 {} {} {} {DD MONTH YYYY}"
> ")
> ##


Assuming that your import code has something similar to:

insert into tbl_inventory(item_id,purchase_date)
	values(1,"2008 7 22 {} {} {} {DD MONTH YYYY}")

I would change it to something like:

insert into tbl_inventory(item_id,purchase_date)
	values(1,regexp_replace('2008 7 22 {} {} {} {DD MONTH YYYY}','{.+} 
*','','g')::date);

Frank