Re: [ADMIN] Datetypes

I use this to start up my postmaster:

su - postgres -c 'export PGDATESTYLE=ISO; postmaster -N 32 -B 256 -i -o "-S 16535 -F" 2>>/var/log/pglog
>>/var/log/pglog'>>/dev/null& 

... which sets the datestyle to ISO.

There is also a sql command called "SET DATESTYLE" but I can't get it to work though...

"Strand Johan F." <johan.f.strand@telia.se> writes:

> Hello there !
>
> How do I do if I want to change the variable
> DATETYPES or PGDATESTYLE to ISO.
> I want to se my date column like this 2000-01-12
> and not 01-12-2000 when I do a select on it.
>
> Thanks
>
> /Johan
> johan.f.strand@telia.se
>
> ************
>
>
>

--
Mattias Norlander
mattias@umc.se