From: iuri de araujo sampaio <iuri.sampaio@gmail.com>
To: pgsql-sql@postgresql.org
Subject: date format
Date: Thu, 24 Jan 2008 05:06:58 -0300
Message-ID: <1201162018.7883.12.camel@COMPAQ> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: iuri.sampaio@gmail.com
Subject: Re: date format
In-Reply-To: <1201162018.7883.12.camel@COMPAQ>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox