On Thursday 24 January 2008 12:06 am, 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}" ") > ##
If this : "2008 7 22 {} {} {} {DD MONTH YYYY}" is indeed the string you are trying to input then it will not work. See- http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATATYPE-DATETIME-INPUT for valid input types. > > 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 -- Adrian Klaver [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org