[SQL] date format

[iuri de araujo sampaio]

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




---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match