Skip site navigation (1) Skip section navigation (2)

Re: date format

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-sql(at)postgresql(dot)org, iuri(dot)sampaio(at)computer(dot)org
Subject: Re: date format
Date: 2008-01-24 15:37:09
Message-ID: 200801240737.10048.aklaver@comcast.net (view raw or flat)
Thread:
Lists: pgsql-sql
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
aklaver(at)comcast(dot)net

In response to

  • date format at 2008-01-24 08:06:58 from iuri de araujo sampaio

pgsql-sql by date

Next:From: Scott MarloweDate: 2008-01-24 15:41:55
Subject: Re: date format
Previous:From: tvDate: 2008-01-24 14:09:09
Subject: Re: SQL tree duplication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group