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

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

From: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, Torello Querci <querci(at)negens(dot)com>
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 15:34:20
Message-ID: 20030910153420.1816.qmail@web41002.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I  think this is what you wanted.

select to_char('03/06/1973'::date,'dd/mm/yyyy');

you were casting the string to a date and returning a
date. so it would return it in a format that your
system is set to return.

agencysacks=# select
to_char('03/06/1973'::date,'dd/mm/yyyy');
  to_char   
------------
 06/03/1973
(1 row)



Ted

--- Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> wrote:
> 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
> 
> 
> -- 
>  Karel Zak  <zakkr(at)zf(dot)jcu(dot)cz>
>  http://home.zf.jcu.cz/~zakkr/
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

In response to

Responses

pgsql-bugs by date

Next:From: Torello QuerciDate: 2003-09-10 15:44:13
Subject: Re: Date 1973/06/03 Conversion Problem in 7.3.4 and 7.3.2.
Previous: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.

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