"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.Liechti@thinx.ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~