From: | iuri de araujo sampaio <iuri(dot)sampaio(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | date format |
Date: | 2008-01-24 08:06:58 |
Message-ID: | 1201162018.7883.12.camel@COMPAQ |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2008-01-24 08:21:02 | Re: date format |
Previous Message | Andreas Joseph Krogh | 2008-01-23 10:25:44 | ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ? |