date format
От | iuri de araujo sampaio |
---|---|
Тема | date format |
Дата | |
Msg-id | 1201162018.7883.12.camel@COMPAQ обсуждение исходный текст |
Ответы |
Re: date format
Re: date format Re: date format Re: date format |
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: