Re: date/time

From: Ian Harding <iharding(at)pakrat(dot)com>
To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-general(at)postgresql(dot)org
Subject: Re: date/time
Date: 2001-01-16 04:51:56
Message-ID: 3A63D4D7.3135B9DF@pakrat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

snef wrote:

> Hi,
> I have read the man's with Postgres.
> But I can't seem to get Postgres use European time notation (dd/mm/yyyy).
>
> Where can I adjust this? (in which file?)
>
> Snef

SET DATESTYLE TO 'SQL, EUROPEAN';
SELECT NOW();

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Niral Trivedi 2001-01-16 16:01:20 pg_shadow permission denied for pgAdmin!!!
Previous Message Tom Lane 2001-01-16 01:49:20 Re: Vacuum causing stange changes in DB

Browse pgsql-general by date

  From Date Subject
Next Message news.postgresql.org 2001-01-16 09:35:31 PostgresqlODBC
Previous Message Adam Haberlach 2001-01-16 03:54:26 Spot the error in my plpgsql...