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

Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.

From: Torello Querci <querci(at)negens(dot)com>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Date: 2003-09-10 14:11:56
Message-ID: 200309101611.56179.querci@negens.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 7.3.2 and 7.3.4 obtain the same result:

template1=# select '03/06/1973'::date;
    date
------------
 1973-03-06
(1 row)

template1=# select '02/06/1973'::date;
    date
------------
 1973-02-06
(1 row)

template1=# select '06/03/1973'::date;
    date
------------
 1973-06-03
(1 row)

template1=# select '06/02/1973'::date;
    date
------------
 1973-06-02
(1 row)




I suppose that the problem is related to the timezone. I make this test:



template1=# select to_timestamp('1973/06/03','yyyy/mm/dd');
      to_timestamp
------------------------
 1973-06-02 23:00:00+01
(1 row)

template1=# select to_timestamp('1973/06/02','yyyy/mm/dd');
      to_timestamp
------------------------
 1973-06-02 00:00:00+01
(1 row)

template1=# select to_timestamp('1973/06/04','yyyy/mm/dd');
      to_timestamp
------------------------
 1973-06-04 00:00:00+02


Alle 15:33, mercoledì 10 settembre 2003, hai scritto:
> On Wed, Sep 10, 2003 at 12:52:22PM +0200, Torello Querci wrote:
> > Hi to all,
> >
> > I have a problem storing 1973/06/03 date.
> >
> > If I send this statement
> >
> >     select to_date('03/06/1973','dd/mm/yyyy');
> >
> > in the psql interface I obtain
> >
> >  to_date
> > ------------
> >  1973-06-02
> >
> > I test this statement with Postgres 7.3.2 and 7.3.4 packaged withMandrake
> > 9.1 and Mandrake 9.2RC1 and obtain the same result.
> >
> > Can anyone help me?
>
>  What's happen if you try:
>
> test=# select '03/06/1973'::date;
>     date
> ------------
>  1973-06-03

In response to

pgsql-bugs by date

Next:From: Daniel SchreiberDate: 2003-09-10 14:28:38
Subject: Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Previous:From: Christoph JaegerDate: 2003-09-10 13:40:38
Subject: Foreign key constraint still active after table row removed

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