Thread: PGDATESTYLE

PGDATESTYLE

From

Sébastien HEITZMANN

Date:

05 June 2001, 17:12:15

How can i set the date default format to European on the 7.1.2 postgres version.

I have passed the -o e option at pg_ctl, tried the PGDATESTYLE=European in postgres.conf, set the PGDATESTYLE environnement var and nothing work.

In the version 7.0 it was working ?

Any idea ?

Thanks.

SEB

Re: PGDATESTYLE

From

Juan Manuel Sende

Date:

19 June 2001, 12:53:54

Sébastien HEITZMANN wrote:

> C'est un message de format MIME en plusieurs parties.
>
> ------=_NextPart_000_00CB_01C0EDF9.2A203F90
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> How can i set the date default format to European on the 7.1.2 postgres
> ver= sion.
>
> I have passed the -o e option at pg_ctl, tried the PGDATESTYLE=3DEuropean
> i= n postgres.conf, set the PGDATESTYLE environnement var and nothing
> work.
>
> In the version 7.0 it was working ?
>
> Any idea ?
>
> Thanks.
>
I'm facing the same problem i would like to get out time in format
xx:xx:xx.xxx so i set TIMESTYLE TO SQL EUROPEAN, but postgres didn't mind
it at all