');
>
> 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
> ---
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
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/');
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