From: | Herbert Liechti <Herbert(dot)Liechti(at)thinx(dot)ch> |
---|---|
To: | "Colin Price (EML)" <Colin(dot)Price(at)eml(dot)ericsson(dot)se>, postgres <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] 6.4.2 and 6.5 date usertype difference |
Date: | 1999-06-29 20:17:34 |
Message-ID: | 377929DD.5BA8F085@thinx.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Colin Price (EML)" wrote:
> I have just replicated a db in 6.5 from 6.4.2.
>
> The table selects the date differently from the identical table.
> I obviously set a parameter in 6.4.2 which I now cannot find (from
> mail list archive and doc as well).
>
> Please aid someone who is tearing his hair out.
> Thank you in advance,
> Colin.
I think you should set the datestyle environment variable $PGDATESTYLE
or executing the sql statement SET DateStyle TO 'whateverYouNeed'. For
further information see the Reference manual in chapter Data Types. You
will find in the section Date/Time Types an explanation how to use
the variable or sql statement.
Greetings Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti E-Mail: Herbert(dot)Liechti(at)thinx(dot)ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Darold Gilles | 1999-06-29 23:42:15 | Re: [GENERAL] 6.4.2 and 6.5 date usertype difference |
Previous Message | Colin Price (EML) | 1999-06-29 19:53:22 | [GENERAL] 6.4.2 and 6.5 date usertype difference |