From: | Mattias Norlander <mattias(at)umc(dot)se> |
---|---|
To: | "Strand Johan F(dot)" <johan(dot)f(dot)strand(at)telia(dot)se> |
Cc: | pgsql-admin(at)postgreSQL(dot)org |
Subject: | Re: [ADMIN] Datetypes |
Date: | 2000-01-12 13:48:09 |
Message-ID: | 86iu0z2yg6.fsf@umc.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)f(dot)strand(at)telia(dot)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(dot)f(dot)strand(at)telia(dot)se
>
> ************
>
>
>
--
Mattias Norlander
mattias(at)umc(dot)se
From | Date | Subject | |
---|---|---|---|
Next Message | Mattias Norlander | 2000-01-12 13:54:55 | Re: [ADMIN] Datetypes |
Previous Message | Strand Johan F. | 2000-01-12 13:35:43 | Datetypes |