Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id F10562E379D
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 24 Jan 2008 04:11:42 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 74704-04-2 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 24 Jan 2008 04:11:31 -0400 (AST)
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.177])
	by postgresql.org (Postfix) with ESMTP id 389792E3877
	for <pgsql-sql@postgresql.org>; Thu, 24 Jan 2008 04:07:05 -0400 (AST)
Received: by wa-out-1112.google.com with SMTP id m38so271537waf.5
	for <pgsql-sql@postgresql.org>; Thu, 24 Jan 2008 00:07:03 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:subject:from:reply-to:to:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding;
	bh=7n5+fXccLLuVALvg/+uRLnFhkOQCDAJtY+VsfDCQ2tI=;
	b=M7xM6zMR9UchzD/Qs/HAOC7fecqKXQeQX39akJ6W8RD9qZLy6JAVhfwObzMTmzTzo3lrh+mgorsUa1Ixx13BAyeN7vKzERusutu3dn/EmYG4enDMe//7knj2N/uks5uHscVNKHSG6qAuRA+FqJ8XFrPaeSBL+ccAE4DVPeuOZhY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:from:reply-to:to:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding;
	b=b83cT1IMpvFQb781UKYrK4EMCE4Qxafsa6bihean8zKmNeIijhipBJdoFbzC288KGXV/zj5avduJjB0Q7Zi8QELR1OMjLzHHFnKZWzGa6HayzvBoZjY8azkgu1Jfl8zxi9dY8DKRb/DPQnWaPW6sWzihxotAXMpUqitoTbq/sfQ=
Received: by 10.142.242.8 with SMTP id p8mr99690wfh.166.1201162023671;
	Thu, 24 Jan 2008 00:07:03 -0800 (PST)
Received: from ?192.168.1.100? ( [189.13.104.245])
	by mx.google.com with ESMTPS id i16sm820667wxd.30.2008.01.24.00.07.00
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Thu, 24 Jan 2008 00:07:01 -0800 (PST)
Subject: date format
From: iuri de araujo sampaio <iuri.sampaio@gmail.com>
Reply-To: iuri.sampaio@computer.org
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Date: Thu, 24 Jan 2008 05:06:58 -0300
Message-Id: <1201162018.7883.12.camel@COMPAQ>
Mime-Version: 1.0
X-Mailer: Evolution 2.12.1 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/178
X-Sequence-Number: 30031

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}"
")
##

I am concerned the input syntax for type date is YYYY-MM-DD. 
as default, postgresql is set to accept the format DD-MM-YYYY for type
date.

so far, i am not able to change the input format and so I need to change
the postgresql type date dafault format. 

best,
iuri