From: Scott Marlowe <scott.marlowe@gmail.com>
To: iuri.sampaio@computer.org
Cc: pgsql-sql@postgresql.org
Subject: Re: date format
Date: Thu, 24 Jan 2008 09:41:55 -0600
Message-ID: <dcc563d10801240741k1e6f62a0lfb5490e018a8310a@mail.gmail.com> (raw)
In-Reply-To: <1201162018.7883.12.camel@COMPAQ>
References: <1201162018.7883.12.camel@COMPAQ>
On Jan 24, 2008 2:06 AM, iuri de araujo sampaio <iuri.sampaio@gmail.com> 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}"
> ")
> ##
Can you give us a statement by statement example of what you're doing?
Are you actually trying to insert the string '2008 7 22 {} {} {} {DD
MONTH YYYY}' as a date?
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: scott.marlowe@gmail.com, iuri.sampaio@computer.org
Subject: Re: date format
In-Reply-To: <dcc563d10801240741k1e6f62a0lfb5490e018a8310a@mail.gmail.com>
* 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